Certification training

Excel VBA Complete Guide

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

175Lectures
10h 15mDuration
Vendor
Excel VBA Complete Guide course cover Best seller
certification training 175 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

12 sections, 175 lessons, and lecture-level duration details.

01 Intro and Course Workbooks download 4m
02 Get the Developer Tab and Intro to Developer Tab 1m
03 Getting started with Range object 1m
04 Quick Tip - Project Explorer and Properties Window! 1m
05 Creating Your First Macro From Scratch 2m
06 Adding a Secondary Command 1m
07 Debugging in Excel VBA 1m
08 Saving a Macro-Enabled Workbook (.xlsm) 1m
09 Before You Begin The Exercises... 3m
10 Several Ways to trigger your Macro 1m
11 Affecting Multiple Cells with One Range Command - 2 Methods 2m
12 Adding Strings of Text to a Cell 2m
13 Using a Named Range with the Range Object 2m

01 .VALUE Property 2m
02 .TEXT Property 1m
03 .ROW and .COLUMN Properties 1m
04 .SELECT Property 1m
05 .COUNT Property 2m
06 .ADDRESS Property 2m
07 .FORMULA Property 4m
08 .NUMBERFORMAT Property 2m
09 FONT.BOLD, UNDERLINE or ITALIC Properties 3m

01 The Cells Object 2m
02 Using Column Letters instead of Numbers 1m
03 Using Cells Positionally within a Range 2m
04 Affecting ALL Cells in a Worksheet 2m
05 Using Range Object with Cells Object 3m

01 Intro to Variables 2m
02 Declaring Variables - Variable Types 3m
03 Declaring Variables - Types Demo 4m
04 Calling a Procedure from Another 2m
05 Public and Private Variables 3m
06 Using Constants 2m
07 BONUS! Passing Variables to Another Procedure - ByVal and ByRef 7m

01 File Menu walkthrough 2m
02 Edit Menu walkthrough 5m
03 View Menu walkthrough 2m
04 View Menu2 - Watch Window, Locals Window and Immediate Window 8m
05 Watch Window Wonders! 3m
06 Insert and Format Menus 1m
07 Debug Menu (Important!) 5m
08 Run and Tools Menus 2m

01 Determining the Last Row in your Data Set 3m
02 Determining the Last Column in your Data Set 2m
03 Determining the Next Row in your Data Set 1m
04 Recording a Macro 4m
05 BONUS! - Dynamic Sorting! 6m
06 Absolute vs Relative References 4m
07 Using With and End With 4m
08 Comparison Operators in Excel VBA 1m
09 If Then Statement 2m
10 Using Is Not Equal To (<>) 1m
11 Logical Operator, NOT 1m
12 If, Then, Else Statement 1m
13 If, Then, ElseIF Statement 2m
14 Comparitive Operators with Text and Numbers! 3m
15 Use If Then Statements in a One-Liner of code 2m
16 Using GOTO and Labels 2m
17 Select Case as Alternative to IF THEN Statements 2m
18 Message Box with Yes and No Buttons 6m
19 Relative Positioning using Offset 4m
20 BONUS - User Defined Functions 101 5m
21 BONUS - UDF Lesson 2 4m

01 Intro to Loops; the For Next Loop 3m
02 Fun with our For Next Loop 4m
03 Beginning our first Report using Loops 6m
04 Using an InputBox 3m
05 Adding InputBox to Our First Report to make it Dynamic 3m
06 Add a Button to Open Our Report 2m
07 Add a Cool Looking Button or Image to Open Report 2m
08 Our First Printable Report part 1 - Declaring and Setting the Sheets 5m
09 Printable Report Part 2 - Getting Items On Report Sheet 7m
10 Printable Report Part 3 - Clearing Last Report 3m
11 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet 4m
12 Exercise 07a - Question 1m
13 Exercise 07a - Answer 11m
14 Using PrintPreview Automatically 1m
15 Using PrintOut to Send Directly to Default Printer 2m
16 Handling Debug Error When Cancelling InputBox 2m
17 For Loop Going Backwards using STEP 3m
18 The FOR EACH Loop 5m
19 FOR EACH Loop - Practical Examples 4m
20 Exercise 07b - Question 1m
21 Exercise 07b - Answer 8m
22 Intro to DO LOOPS 3m
23 DO Until 2m

01 Intro to Worksheet Events and Selection_Change 4m
02 Worksheet Activate Event 1m
03 Worksheet Deactivate Event 2m
04 BeforeDelete Event - for Worksheet Deletion 1m
05 BeforeDoubleClick Event - Trigger a Macro when Double Clicking 3m
06 BeforeRightClick Event - Trigger a Macro when Right-Clicking 2m
07 Calculate Event 3m
08 How to Disable Events on the Workbook 2m
09 Intro to Change Event 1m
10 Change Event with EnableEvents toggle - Avoid endless loop! 5m
11 Change Event Triggered with Custom Range Using Intersect 3m
12 FollowHyperlinks Event 3m
13 Final Thoughts on Worksheet Events and Review Other Events 2m

01 Workbook Open 5m
02 Workbook Activate 2m
03 Before Save 2m
04 After Save 2m
05 Before Close 4m
06 Before Print 1m
07 Deactivate 1m
08 NewChart 3m
09 NewSheet 2m
10 Exercise 09 - Question 1m
11 Exercise 09 - Answer 5m
12 Sheet Activate 2m
13 Delete, DoubleClick, RightClick, Calculate, Change 5m
14 SheetDeactivate 3m
15 Follow Hyperlink 1m
16 SheetSelectionChange 1m
17 WindowActivate 1m

01 Activex Controls vs Forms Controls 4m
02 Button Click - Wage Calculator 4m
03 Keydown Event 4m
04 BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable 3m
05 KeyPress Event 3m
06 MouseMove Event 2m
07 MouseMove Event with Application.Statusbar - fun and useful 4m
08 MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl 6m
09 GotFocus and LostFocus Events 1m
10 Use a Checkbox for its VALUE 3m
11 Checkbox Event Without a Button 2m
12 LinkedCell Property with a Checkbox 2m
13 Option Buttons Intro - What is an Option Button and Grouping 3m
14 Grouping, Alignment and Aesthetics for Controls 3m
15 Homemade Quiz using Option Buttons and a Command Button 5m
16 Compliance Checker for your Forms or Quizzes Part 1 4m
17 Compliance check part 2 10m
18 SpinButton with Cell A1 4m
19 SpinButtons with Textboxes and Numbers 6m
20 SpinButton BONUS - Move Textbox Position with SpinButton 4m
21 SpinButton with Dates in a Textbox 4m
22 Activex "Label" Control - Basics 4m
23 ComboBox - Fill with ListFillRange 4m
24 Creating a Dynamic Range 5m
25 ComboBox - How to use Multiple Columns 3m
26 Using .ADDITEM to Get Specific items in your Combobox List 9m
27 Noteworthy Properties of a Combobox 6m
28 Multiple Columns in Combobox with.ADDITEM and List, ListCount etc 7m
29 ListBox Basics using Dynamic Range 8m
30 Listbox Click event and Dynamic Options 3m
31 BONUS - Manipulating and Using Multiselect Items in a Listbox 6m
32 ListBox - Referencing Column 0 and 1 in a cell Dynamically! 4m
33 Dynamic ListBoxes Using .ADDITEM and More 10m
34 Make and Utilize INVISIBLE Columns - Special Trick! 4m
35 Using a Scroll Bar on a worksheet 3m
36 Pictures on a Worksheet, plus using FollowHyperlink Method 6m
37 Toggle Button 2m
38 A Brief Note on Alternate, 3rd Party Controls 2m

01 Userform - Hide, Show and Unload 5m
02 Sample Database and Creating a Data Entry Form 6m
03 Fill Status combobox with Rowsource when Userform starts - 2 methods 4m
04 New Employee Data Entry Form! 9m
05 Format Textbox Numbers as Numerals, Clearing out Form upon Submission 3m
06 Set the Tab Order for Userform Controls 2m
07 Set Default Values to Make Data Entry Easier 2m
08 Avoid Duplicate Employee ID and other Fun Automation Tricks 13m
09 Edit Mode for Employee Database - Part 1 11m
10 Edit Mode for Employee Database - Part 2 8m
11 Edit Mode Pt 3 - Adding Automation and Save Button 16m
12 Userform Report with Filters - Part 1 11m
13 Userform Report with Filters - Part 2 6m
14 Applying the Dynamic Filters to Reports 3m
15 Clear out Last Report 3m
16 Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc. 6m
17 Concluding Thoughts 3m

01 InStr Function - Search for Text Within Other Text 7m
02 The EVALUATE Function - Mac-Daddy of all functions 6m
03 Sum Function in Excel VBA - EASY! 3m
04 Count Function in VBA 2m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.