Great Canadian Training Company color logo

Microsoft Excel VBA Complete
(2013, 2016, 2019, 2021, 365)

What You'll Learn in Microsoft Excel VBA Complete

Course Length:

12 hours (2 days)

Learning Objectives

In this course, you will:

 

  • Record and Run Simple Macros
  • Use the VB Editor and Code Window
  • Create and Edit VBA Code
  • Work with Objects
  • Work with Variables
  • Create Procedures and Functions
  • Work with Forms and Controls
  • Understand Debugging

Target Student

This course is designed for students who need to automate repetitive tasks and create simple macros that run in spreadsheets. Knowledge of Excel spreadsheets is recommended.

Course Outline

Section 1: Basic Macro Concepts

How to Record a Macro

Re-recording a Macro

How to Play, Delete, Edit and Rename a Macro

Using Relative Referencing

Running a Macro While Recording Another

Section 2: Macro Security

Section 3: Personal Macro Workbook

Section 4: Dealing with Ranges That Change Size Over Time

Section 5: 8 Different Ways to Run a Macro

Adding to Ribbon, Creating Buttons, etc.

Section 6: Visual Basic for Applications - Basics

The Visual Basic Editor

The VBA Toolbars

Modules

Protecting a Module

Section 7: Writing Code

Objects, Properties and Methods

Using the With Construct

Recording vs. Writing – Pros and Cons

Getting Help with the Object Browser

Declaring and Using Variables

Using Formulas in Macros

Section 8: User Interaction

Input Boxes and Message Boxes

Formatting Input or Message Boxes with the Format Function

Section 9: Adding Special Characters Including Line Breaks

Section 10: IF Statements

Message Boxes That Allow for Input

Section 11: Running Other Procedures

Section 12: Event Trapping

On Error

Auto_Open() and Auto_Close()

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Excel VBA Complete

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
April 10-11, 2024
9:00 AM to 4:00 PM ET
$825.00 Online
July 17-18, 2024
9:00 AM to 4:00 PM ET
$825.00 Online
September 12-13, 2024
9:00 AM to 4:00 PM ET
$825.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training


Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices


Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!


Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference