"Today, no accomplished Excel programmer can afford to be without John's book. The value of "Excel 2003 Power Programming with VBA" is double most other books - simultaneously the premier reference and best learning tool for Excel VBA." - Loren Abdulezer, Author of "Excel Best Practices for Business". It contains 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; and 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. The 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[trademark] or later". "Microsoft Excel 2003" - see the 'What's on the CD' Appendix for details and complete system requirements.
Preface.Acknowledgments.Part IExcel 2003: Where It Came From.Chapter 2: Excel in a Nutshell.Chapter 3: Formula Tricks and Techniques.Chapter 4: Understanding Excel's Files.Part II: Excel Application Development.Chapter 5: What Is a Spreadsheet Application?Chapter 6: Essentials of Spreadsheet Application Development.Part III: Understanding Visual Basic for Applications.Chapter 7: Introducing Visual Basic for Applications.Chapter 8: VBA Programming Fundamentals.Chapter 9: Working with VBA Sub Procedures.Chapter 10: Creating Function Procedures.Chapter 11: VBA Programming Examples and Techniques.Part IV: Working with UserFormsChapter 12: Custom Dialog Box Alternatives.Chapter 13: Introducing UserForms.Chapter 14: UserForm Examples.Chapter 15: Advanced UserForm Techniques.Part V: Advanced Programming Techniques.Chapter 16: Developing Excel Utilities with VBA.Chapter 17: Working with Pivot Tables.Chapter 18: Working with Charts.Chapter 19: Understanding Excel's Events.Chapter 20: Interacting with Other Applications.Chapter 21: Creating and Using Add-Ins.Part VI: Developing Applications.Chapter 22: Creating Custom Toolbars.Chapter 23: Creating Custom Menus.Chapter 24: Providing Help for Your Applications.Chapter 25: Developing User-Oriented Applications.Part VII: Other Topics.Chapter 26: Compatibility Issues.Chapter 27: Manipulating Files with VBA.Chapter 28: Manipulating Visual Basic Components.Chapter 29: Understanding Class Modules.Chapter 30: Frequently Asked Questions about Excel Programming.Part VIII: Appendixes.Appendix A: Excel Resources Online.Appendix B: VBA Statements and Functions Reference.Appendix C: VBA Error Codes.Appendix D: What's on the CD-ROM.Index.End-User License Agreement.