Excel 2003 Power Programming with VBA
--Loren Abdulezer, Author of Excel Best Practices for Business
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.
* 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(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.
Part I: Some Essential Background.
Chapter 1: Excel 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 UserForms
Chapter 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.
End-User License Agreement.