Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Introduction to VBA Programming

Learn basic skills and important concepts of VBA programming including variables, forms and arrays.

GK# 6944

Course Overview


Introduction to VBA will acquaint new programmers with what VBA can do and with its programming environment. Basic skills and important concepts of VBA are taught.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • Use variables
  • Forms
  • Conditions and Loops
  • Arrays
  • Use a calendar control
  • CodeTest


Viewing outline for:

Classroom Live Outline

Get Started

  • What is VBA?
  • The Visual Basic Editor
  • Understand code
  • Get explanations
  • Use online references
  • Work with different applications
  • A little more code and some lists
  • Write code
  • Display a message box

Use Variables

  • Make a procedure accessible
  • Revise code
  • Create a form and its code


  • Start a new form
  • Add controls
  • Add the code
  • Test the code
  • Show the form

Conditions and Loops

  • Use conditions and loops 
  • For Each
  • Next and If Then
  • User interaction variations
  • Do While
  • Loop
  • Select Case


  • Use an array and add to collections
  • Consider the possibilities
  • Set up the array
  • Declare the command bar and controls
  • Make them work together
  • Add a functionTest and clean up

Use a Calendar Control

  • Create a form and controls
  • Set control properties


  • Write the code
  • Test and refine
  • Deal with a modal form
  • Fix bugs and handle errors
  • Find the bug
  • Fix the bug
  • Test for errors
  • Write an error handler



Prerequisites include intermediate to advanced training on Word and Excel or equivalent working knowledge of each software program.

Who Should Attend


This course is designed for students interested in learning general programming concepts. This course also provides a foundation for students desiring to learn one or more programming languages.

Training Exclusives

This Office course comes with extended access to the following benefits:

  • Concept Training
  • ClipTraining Video Library
  • Free Refreshers
  • Online Course Content
Learn More >
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.