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
Interacting with Other Applications
Working with External Data and Files
Working with UserForms. Leveraging Custom Dialog Boxes
Looking at UserForm Examples
Implementing Advanced UserForm Techniques
Developing Excel Applications. Creating and Using Add-Ins
Working with Shortcut Menus
Providing Help for Your Applications
Understanding Compatibility Issues
Appendix: VBA Statements and Functions Reference.