Microsoft Office Training ltd

Introduction to Macros and VBA

Introducing Visual Basic for Applications

Recording a Macro

Naming conventions for Macro Procedures

Running a Macro

Absolute or Relative Cell Referencing

Saving and Opening Files with Macros

Making macros always available

Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes

Editing a Macro in the Visual Basic Editor

Understanding the Development Environment

Customising the Editor

Tips for General Typing in VBA

Using Visual Basic Help

Working with Procedures

Program Design

Understanding Modules

Naming Rules

Creating a Module

Understanding Procedures

Programming Macro Concepts

Creating a Subroutine

Creating a Function

Understanding Arguments

Exiting Procedures

Calling Procedures

Objects, Properties, Methods and Events

Understanding Objects Properties, Methods, and Events

Navigating the Object Hierarchy

Understanding Collections

Accessing a Member of a Collection

Understanding Hierarchy

Using the Object Browser

Using the With Statement

Working with Properties

Working with Methods

Creating an Event Procedure

Reserved Macro Names

Using Expressions, Variables and Intrinsic Functions

Understanding Expressions and Statements

Declaring Variables

Understanding Data Types

Determining the Value of Variables

Working with Variable Scope

Using Built-in VBA Functions

Understanding Constants

Using Message Boxes

Controlling the Answer to a Message Box

Using Input Boxes

Declaring and Using Object Variables

Controlling Program Execution

Understanding Control-of-Flow Structures

Using the If...End If Decision Structures

Nested If Statements

Using the Select Case ... End Select Structure

Using the Do ... Loop Structure

Using the For ... Next Structure

Using the For Each ... Next Structure

Guidelines for Use of Control-of-Flow Structures

Debugging and Handling Errors

Understanding Errors

Using Debugging Tools

Setting Breakpoints and Using Break Mode

Stepping Through Code

Trapping Errors with the On Error Statement

Understanding the Err Object

Working with Inline Error Handling

Writing an Error-Handling Routine

Working with Forms and Controls

Understanding UserForms

Creating a Form

Displaying and Removing a Form

Aligning and Sizing Controls

Using the Toolbox

Working with a Form's Properties, Methods, and Events

Working with Form and Control Properties, Methods and Event

Setting the Tab Order

Populating a Control

​

​