Excel 2021 VBA Beginner Tutorial

This beginner course introduces VBA for Excel automation, from recording and editing macros to using the Excel object model, modules, procedures, and functions. It also covers variables, control flow, forms, Pivot Tables, debugging, and error handling.

Syllabus

Start
Introduction
VBA Basics
Getting Started
Example of Object-Oriented Programming Using Excel
Why VBA?
VBA vs Macros
Adding the Developer Tab to the Ribbon
Filling in the Record Macro Dialog
Recording Macros
Testing Macros
Exploring VBE
Viewing VBE Options and Reviewing Macro Code
Editing Macro Code and Using Project Explorer and Properties
Adding Useful Commands to the Toolbar
Saving Macro-Enabled Workbooks
Testing Edited Macros
Reviewing and Changing Security Settings
VBA Basics Recap
Excel Object Model Hierarchy and Collections
Referencing Objects and Simplifying Object References
Introduction to Modules and Procedures
Understanding Modules
Understanding Procedures
Recording More Macros
Creating Sub-Procedures from the Menu in VBE
Reviewing New Code and Editing Existing Code
Creating Calling Procedures
Testing Calling Procedures
Creating Event Procedures
Creating Function Procedures
Reviewing and Testing Function Procedures
Getting Context Sensitive Help in VBE
Modules and Procedures Recap
Conclusion