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..
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