Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
VBA Launch Pad
Course Content
Expand All
Platform Introduction
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Course Examples
Course Introduction
Who’s Ken
Extend Your Access
Introduction to Macros and VBA
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Macros vs VBA
Creating a Macro
Macro Security Settings
Running a Macro
Editing VBA Macros
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
VBA Structure
The Visual Basic Editor (VBE)
Editing a VBA Macro
Debugging
Enriching and Writing Code
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Why the Macro Recorder isn’t Enough
With Blocks
Introduction to Variables
Making Use of Variables
Option Explicit
Writing a Macro from Scratch
Coding Constructs
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Message Boxes
Input Boxes
If Then Else
Select Case
Do Loops
For Loops
Looping Practice
Intermediate Coding Concepts
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Error Handling
Advanced Error Handling
Code Encapsulation
Functions
Using Functions in VBA
Using a UDF in a Worksheet
Scope
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Procedure Scope
Variable Scope – Part 1
Variable Scope – Part 2
Declaring Constants
Events
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
What are Events
Workbook_Open
Workbook_BeforePrint
Worksheet_Activate
Worksheet_SelectionChange
Worksheet_Change
Handling Recursion Using a Counter
UserForms
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Creating UserForms
Passing Results To-From Userforms
Populating Userform Controls on Load
The Potential of Userforms
Practice Projects
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Automate PivotTable Refresh
Export Active Sheet to PDF
Export Multiple Sheets to One PDF
Export Each Sheet to PDF
Help Resources
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Free Help Forums
Free Blogs
Free Newsletters