Everything you need to know about:

• Creating stellar UserForms and custom dialog box alternatives
• Working with VBA subprocedures and function procedures
• Incorporating event-handling and interactions with other applications
• Building user-friendly toolbars, menus, and help systems
• Manipulating files and Visual Basic® components
• Understanding class modules
• Managing compatibility issues

Feel the power of VBA and Excel

No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes

• Trial version of the author’s award-winning Power Utility Pak
• Over one hundred example Excel workbooks from the book

System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. microsoft Excel 2003. See the "What’s on the CD" Appendix for details and complete system requirements.

Book Info
Guide to Excel VBA, showing how to create UserForms and custom dialog box alternatives, working with VBA subprocedures and function procedures, managing compatibility issues, and more. Softcover.

Key Book Benefits:

• This immensely popular tutorial for Visual Basic has been fully revised for the newest version of the technology.

• Provides step-by-step guidance on how to use Visual Basic 2005 with Visual Studio 2005 to create smart-client and Web applications.

• Features easy-to-follow, logically planned lessons, with necessary data sets and additional code samples on the CD.

• STEP BY STEP is ideal for anyone with a fundamental understanding of computer programming.

"Daughter of the Yellow River is a testament to perseverance, determination, courage, and success." – Deepak Chopra, best-selling author of Peace Is the Way

"Diana Lu’s memoir effectively weaves autobiography, advice, cultural insights, and career journey to reveal what many women already know: work is intensely personal. Her self-reflection is contagious, and hopefully her perseverance will be as well." – Joanne Gordon, former Forbes staff writer and author of Career Bliss: Secrets from 100 Women Who Love Their Work

"Daughter of the Yellow River is an inspiring story of a remarkable woman. From the deprivation of the Chinese Cultural Revolution to success in the Western world, it depicts the victory of determination and pluck over personal and business adversity." – James Pammenter, former director, KPMG management Consulting

"This book vividly proves the power of ‘You will never know until you try.’ Diana Lu provides a simple, compelling approach to building the life of our dreams. This is an authentic road map for anyone pursuing lasting and transformational change in their lives." – Darryl Quan, chief financial officer, Image Global Impact.

"Diana’s beauty masks a dynamic entrepreneur who knows what she wants to do and does it. Her life story takes her from the struggles of an impoverished childhood in china to success in a highly competitive global industry to a commitment to helping people forge their own paths to fulfillment. She shares her challenges and disappointments, triumphs and achievements, and the lessons she has learned about business and about life." – John Edward, former divisional director, Corning Incorporated.

"Inspirational, motivational, and stimulating are words that describe this book. Diana Lu’s ‘can do, can achieve’ attitude makes this book a must for those who want to get more out of life. She is proof that if you are an intelligent woman dealing in a male-dominated industry, you can be successful while maintaining an air of sophistication and femininity." – Mike Yell, general manager, Fujitsu Australia & New Zealand

When Diana Lu was three years old, her family was forced to leave their comfortable middle-class life in the city to live an impoverished coal-mining village at the edge of the Gobi Desert for China’s culture revolution "re-education."

Life in that remote place was a constant struggle against hunger and fear. Passionate & determined, Diana resolved to create a better life based on her own talents and dreams; she turned down prestigious job after medical school. Overcoming parental & societal objections, she explored university teaching, real estate, and other fields before finding her niche as a top executive in the optical fiber industry. In 1997 Diana moved to the United States, and launched her own international enterprise, melding the Western & Chinese business cultures to work with clients globally.

Operating in a competitive, male-dominated high-tech field, she achieved astounding success -- from earning $30 a month in 1993 to in ten years making sales worth hundreds of millions of dollars. This inspirational book -- part memoir, part guidebook to personal and business success -- illustrates her remarkable journey.

* I am a daughter of the Yellow River. Its waters flow within me like the blood in my veins.

* I didn't need to define or limit myself by the circumstances I came from -- what counted was where I was heading.

* I realized that our lives will be what we choose to make them… That can be a daunting challenge, but the rewards are immeasurable.

• Mastering operators, error values, naming techniques, and absolute versus relative references
• Debugging formulas and using the auditing tools
• Importing and exporting XML files and mapping the data to specific cells
• Using Excel 2003’s rights management feature
• Working magic with array formulas
• Developing custom formulas to produce the results you need

Here’s the formula for Excel excellence

Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel’s capacity.

CD-ROM Includes

• Trial version of the author’s award-winning Power Utility Pak 5
• More than 90 sample workbooks illustrating key formula concepts

Timothy is a technical editor with the microsoft Project UA group, and he previously worked as a Project support professional for six years. He possesses in-depth technical knowledge about the software.

Mark has a B.S. from Carnegie Mellon University and an M.S. from Rennselaer Polytechnic Institute, both in computer engineering. In 1994, he earned a Ph.D. from Carnegie Mellon University, also in computer engineering. Before founding Winternals Software, he worked at Compuware NuMega Laboratories and IBM’s Thomas J. Watson research Center.

David Solomon has focused on explaining the internals of the Windows NT operating system line since 1992. He has taught his world renowned Windows Internals classes to thousands of developers and IT professionals worldwide. His clients include all the major software and hardware companies, including Microsoft. He was a recipient of the 1993 microsoft Support Most Valuable Professional (MVP) award.

This is David's fourth book. His first book was Windows NT for OpenVMS Professionals (Digital Press/Butterworth Heinemann, 1996). It explained Windows NT to VMS-knowledgeable programmers and system administrators. Prior to starting his own company, David worked for nine years as a project leader and developer in the VMS operating system development group at Digital Equipment Corporation. His second book, Inside Windows NT 2nd edition, covered the internals of Windows NT 4.0. His third book, Inside Windows 2000 3rd edition, was co-authored with Mark Russinovich.

In addition to organizing and teaching seminars, David is a regular speaker at technical conferences such as microsoft TechEd and microsoft PDCs. He has also served as technical chair for several past Windows NT conferences. When he's not researching Windows, David enjoys sailing, reading, and Star Trek.

What do customers ultimately buy after viewing items like this?

93% buy the item featured on this page: microsoft Windows Internals, Fourth Edition: microsoft Windows Server(TM) 2003, Windows XP, and Windows 2000 (Pro-Developer) by Mark E. Russinovich $37.79

4% buy Win32 programming (Addison-Wesley Advanced Windows Series) by Brent E. Rector $60.32

2% buy Windows Internals: The Implementation of the Windows Operating Environment (The Andrew Schulman programming Series) by Matt Pietrek $34.95

1% buy Win32 System Programming: A Windows(R) 2000 Application Developer's Guide (2nd Edition) by Johnson M. Hart $59.99

  Explore Similar Items