MS Excel 2007 Power Programming with VBA

Fully updated to the new version of Microsoft Office, Excel 2007 Power Programming with VBA includes everything you need to know about exploiting the power of this highly programmable application. No one can uncover Excel s hidden capabilities like "Mr. Spreadsheet" himself. In this power user’s guide, John Walkenbach shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, 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 includes a trial version of the author’s award-winning Power Utility Pak and over one hundred example Excel workbooks from the book.