Excel 2002 power programming with VBA - John Walkenbach

Excel 2002 Power Programming with VBA Develop Powerful, User–Oriented Excel 2002 Applications With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel–and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well–thought–out examples, he walks you through the basics of Excel application development and VBA programming–and then gives you a lucid, wide–ranging seminar on advanced programming techniques and application development issues. It's all you need to create user–oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development
* Take Excel to the next level with formula tricks and techniques
* Work with VBA sub procedures and function procedures
* Create stellar UserForms as well as custom dialog box alternatives
* Develop applications that maximize the power of PivotTables and charts
* Incorporate event–handling and interactions with other applications
* Build user–friendly toolbars, menus, and help systems
* Manipulate files and Visual Basic components and understand class modules
* Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD–ROM Includes
* A trial version of the author's award–winning Power Utility Pak 2000
* A demo of the author's Sound–Proof 2000
* Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com