Introduction to Excel VBA. Essentials of Spreadsheet Application Development -- Introducing Visual Basic for Applications -- VBA Programming Fundamentals -- Working with VBA Sub Procedures -- Creating Function Procedures -- Understanding Excel’s Events -- VBA Programming Examples and Techniques -- Advanced VBA Techniques. Working with Pivot Tables -- Working with Charts -- Interacting with Other Applications -- Working with External Data and Files -- Working with UserForms. Leveraging Custom Dialog Boxes -- Introducing UserForms -- UserForm Examples -- Advanced UserForm Techniques -- Developing Excel Applications. Creating and Using Add-Ins -- Working with the Ribbon -- Working with Shortcut Menus -- Providing Help for Your Applications -- Leveraging Class Modules -- Understanding Compatibility Issues -- Appendix. VBA Statements and Function
Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) - with over 800 pages of tips, tricks, and best practices, this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. -- Edited summary from book.