"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.