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

Subprocedures/Subroutines

Comments

The MsgBox

The InputBox

 

Variables & Constants

A General Introduction to Storage

Variables and Constants, Variable Types

 

Objects

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

Scope

Calling functions from subprocedures

UDFs

 

Debugging & Error Handling

Types of Errors and How to Handle Them

Investigating Problems Using the Debug Window

 

Class Project

Creating a user application