Excel VBA Programming for Dummies

Harness the power of VBA to create custom Excel applications

Showing you how to take advantage of the features in the new Excel 2013, John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized Excel 2013 solutions using Visual Basic for Applications (VBA). Using step-by-step instruction and the easy-to-understand "For Dummies" style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.Introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic EditorProvides an overview of the essential elements and concepts for programming with ExcelShares techniques for handling errors, debugging, working with range objects, controlling flow, and much moreZeroes in on creating custom dialog boxes, toolbars, and menus

With "Excel VBA Programming For Dummies, 3rd Edition," you will be creating Excel applications custom fit to their unique needs in no time.

John Walkenbach, known to his fans as Mr. Spreadsheet, has written some 50 books and around 300 articles on computer topics, predominantly Excel. He created the award-winning Power Utility Pak and several other versatile Excel add-ons. John maintains the Spreadsheet Page at http://spreadsheetpage.com.