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.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
More Information