Excel VBA Introduction

Course Overview 

This course is designed for users familiar with Excel who have little or no knowledge of computer programming, but who would like to learn how to program features and functions to improve the accessibility and usability of their data.  At the end of the training course you will have covered the fundamentals of VBA (Visual Basic for Applications), including creating procedures and functions, variables and objects, user forms, debugging and error handling

We offer four weeks free consultation on completion of this course.

Course Content (2 days)

VBA Overview

Overview of the Project Explorer

The Macro Recorder



The MsgBox

The InputBox


Variables & Constants

A General Introduction to Storage

Variables and Constants, Variable Types



The Object Browser

The Object Hierarchy/Model

  • Properties
  • Methods
  • Events


Control Structures

Determining the Flow of a Program

Branching – If statements/Select Case

Looping – For Each/For/Do/While/Until



Subprocedures & Functions

The structure of a VBA subprocedure


Calling functions from subprocedures



Debugging & Error Handling

Types of Errors and How to Handle Them

Investigating Problems Using the Debug Window


Class Project

Creating a user application