$385.00 CAD / 1 DAYS

1) Select Location for Dates in Your City:

Choose Date

Don't see dates in your city?

Select From Home or Office or contact us below.

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.


Jump to Shopping Cart Continue shopping

VBAINT: Introduction – Programming


Duration: 1 day

Course Description

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.


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

Course Content

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


Today only!


Sign up today at Global Knowledge and save 50% off eligible courses!


Select your course here >

Don’t miss out!

newsletter sign-upSign up for desktop training news on upcoming webinars, free resources, new courses, offers and more.