Master the programming features in Excel 2002 and unleash the power of VBA with expert guidance from "Mr. Spreadsheet" - expert author John Walkenbach!This is the ideal guide for Excel developers who want to get the most out of Excel with VBA, more than they ever thought was possible. It's also perfect for beginning developers who want to quickly learn how to tap the full potential of Excel programming using VBA. Includes:* Explanation of effective techniques of Excel Application Development* Thoroughly explains how to use Visual Basic for Applications to add power to Excel Applications* Gives tricks and tips for interacting with other applications* Presents info on how to develop Excel utilities with VBA* Explores the Data Access Object, the powerful feature that makes it easier to work with external database files in VBA* Shows how to create custom menus, toolbars, help applications, and more* Gives complete instructions on how to use VBA to design and create 3D charts* Teaches VBA by presenting extensive code examples in the text* Provides hundreds of useful examples that demonstrate the most effective methods for implementing VBA"