Страниц: 408 ISBN: 9781118490372 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 Editor Provides an overview of the essential elements and concepts for programming with Excel Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more Zeroes in on creating custom dialog boxes, toolbars, and menus With Excel VBA...
