OUTLINE

DURATION:  2 DAYS (16 HOURS)

DIFFICULTY LEVEL: ADVANCED

1.  Macro recording

Recording and Running Macros

Running a Macro

Adding a Macro/Procedure to the Quick Access Toolbar

The Personal Macro Workbook 

2.   The VBA development environment

VBA and VBE

Editing Macros in VBE

Understanding the Development Environment

Understanding macro security settings 

3.   Understanding and Creating Modules

Defining Procedures and creating a Sub-Procedure

Working Using the Code Editor 

4.   Variables and Expressions

Defining Expressions and Statements

How to Declare Variables

Naming Variables

Assigning Values To Variables

Declaring Variables Explicitly

Determining Data Types

Programming with Variable Scope 

5.   User-defined Functions

Creating a Function Procedure

Calling a UDF

Using a function within an Excel Workbook 

6.   Defining Objects

Examining the Excel Object Hierarchy

Defining Collections

Working with Properties

The With Statement

Working With Methods

Event Procedures

Self-starting procedures 

7.   Loops

Loop guidelines

Using the For Each...Next Structure 

Using the If...End If Decision Structures

Looping through workbooks and worksheets

Looping through cells and ranges 

8.   UserForms and Controls

Creating UserForms and Controls

Using UserForm Properties, Events And Methods

Coding, Userforms, Controls and user interactivity 

9.   Error handling

VBA's Error Trapping Options

Capturing Errors with the On Error Statement

Determining the Err Object

Coding an Error-Handling Routine