Reasons for using VBA rather than Macros

Understanding the Development Environment

The Visual Basic Editor, Parts of the Screen

Code colours, Using Visual Basic Help

Modules, Procedures

Creating a Sub Procedure

Call Sub Procedures

Creating and Use Function Procedures

Understanding Classes and Objects

Navigating the Excel Object Hierarchy

Understanding Collections

Using the Object Browser

Working with the Application Object

Using Properties and Methods

Using the With Statement

Working with Events

Order of Events

Declaring Variables, Understanding Data Types

Working with Variable Scope

Using Intrinsic Functions

Understanding Constants

Using Message Boxes, Using Input Boxes

Understanding Control-of-Flow Structures

Working with Boolean Expressions

Using the If...End If Decision Structures

Using the Select Case...End Select Structure

Using the For...To Next For Each Next Structures

Using the Do...Loop Structure

Error Types, Minimising Errors

Setting Breakpoints, Stepping through Code

Handling Errors

Understanding Error Handling

On Error Statement,

Understanding the Err Object

Writing an Error-Handling Routine

Working with Inline Error Handling