Automate tasks and procedures in Excel using Visual Basic for Applications (VBA).
Utilize the objects in the Excel Object Model to emulate user actions in Excel.
React dynamically to user events like entering a cell value or opening a workbook.
Feel comfortable with the fundamentals of computer programming.
Over the course of more than 18 hours of content, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:
The Excel Object Model
The Visual Basic Editor
Objects and Methods
Variables and Data Types
Writing Your Own Procedures
The Workbooks and Workbook Objects
The Worksheets and Worksheet Objects
Range References
Range Actions
Conditional Logic
Iteration
Alerts
Configuring Excel Functionality
Custom Functions
Arrays
Debugging
Even Procedures
User Forms