VBA eBooks

Download free VBA eBooks

Excel VBA Programming

For Dummies

3rd Edition

Take control of your spreadsheets and use VBA to create your own custom Excel applicationsAuthor and Excel guru 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 spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling 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 2013 options, beginning with the most important tools and operations for the Visual Basic EditorProv...

Writing Excel Macros

With VBA

2nd Edition

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the reta...

VB & VBA in a Nutshell

The Language

The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB VBA in a Nutshell: The Language, it finally is available.The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information: Its syntax, using standard code conventions Differ...