(With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as Mr. Spreadsheet, you ll quickly learn how to harness the full programming power of Excel 2000 from UserForms to class modules)
Microsoft® Excel 2000 Power Programming with VBA With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 — from UserForms to class modules. Take Your Spreadsheets to a Whole New Level
- Master the overall design-development-deployment process for Excel applications
- Take complete control of the Visual Basic Editor environment
- Learn how to work with VBA objects, subprocedures, and functions
- Explore basic to advanced techniques for building intuitive UserForms
- Use VBA to develop robust Excel utilities from the ground up
- Find out how to program Excel to respond to a wide variety of events
- Discover how to automate charts and pivot tables in your applications
- Create custom toolbars, menus, and help files
- Figure out how to manipulate text files and Visual Basic Project components at design time
- Understand what class modules are and how to use them
More than 150 example files on CD-ROM, plus a free copy of John Walkenbach's Power Utility Pak www.hungrybinds.com