This advanced VBA course builds on the foundation from Level I and takes your macro skills to the next level. You'll learn to automate more complex tasks, streamline workflows, and apply everything you've learned across Excel in a faster, more powerful way.
To get the most out of this course, you'll want to come in with a solid grasp of the core macro concepts covered in our Level I VBA class. With that foundation in place, you'll be well positioned to unlock the full potential of everything taught across our Excel courses.
What You Will Learn
- Navigate workbooks using offsets, named ranges, and variables
- Analyze data by combining looping structures with If and Case statements
- Build user interface structures to capture multiple variable inputs
- Control the lifespan and scope of your variables
- Create automated, event-driven processes
- Handle unexpected errors and events with reliable automation
Course Outline
Lesson 1: VBA Editor
-
Project Explorer
-
Properties Window
-
Modules
Lesson 2: Creating / Editing Code
Lesson 3: Invoking Macros
-
Worksheet Buttons
-
Customize Ribbon
Lesson 4: Compiling Code
-
Stepping through code
-
Setting Breakpoints
Lesson 5: Variables
-
Declarations
-
Option Compare Text
-
Option Compare Binary
-
Lifetime and Scope
Lesson 6: Working with The Object Model
Lesson 7: Creating & Naming Objects
-
Naming conventions
-
Housekeeping
Lesson 8: Navigation / Selection Techniques
-
Absolute versus Relative Reference
-
Offsets
Lesson 9: Logic Statements
-
Nested IF Statements
-
Case Statements
Lesson 10: Functions
-
Intrinsic Functions
-
User Defined Functions
Lesson 11: Looping Statements
Lesson 12: Interactive Code
-
User Forms - dashboards
-
Message Boxes
Lesson 13: Error Handlers
-
Error numbers
-
Error descriptions
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
