Contents
Introduction to Excel VBA
What Is VBA?
The Difference Between VBA and A Macro
The Structure of A VBA Code
The VBA Module Outline
VBA Procedures and Routines
Sub procedures
Function procedures
The Meaning of Statements
Declaration statements
Executable statements
Assignment statements
Objects
Classes
The Purpose of Collections
The Relationship Between Different Objects
Properties
Methods
Variables and Arrays
Conditions
Loops
Getting Used to the Developer Toolbar
Understanding the VBA Development Environment
Check out your first recorded macro
Understanding Excel Dot Notation
Conditional Logic
VBA Examples and Techniques
Copy and Paste
Adding Buttons to Help You Stay Organized
The Most Popular Excel Functions
Frequent Troubleshooting
Conclusion