Introduction to Microsoft Office Excel Macros
and VBA

Macros Management

Recording and Running Macros

Using a Personal Macro Workbook

Running Macros Using The Quick Access Toolbar

Running Macros Using Hotkeys

Running a Macro From Within Another Macro

Macro Security

Macro Security Setting Considerations

Understanding Digital Certificates and Signatures

Introduction to Visual Basic for Applications

Understanding the Visual Basic Editor Interface

Examining Module Design

Review of Excel Objects, Properties, and Methods

Editing a Macro Using the Visual Basic Editor

How to Debug a Macro

Using Loop Structures in VBA Code

Using a For...Next Statement

Using a Do...Loop Statement

Declaring and Using Variables in VBA

Understanding "With…End With" Syntax

Interactive Macros

Creating a Custom Message Box

Creating a Custom Input Box

Working With VBA Decision Making Code

The Select Case Decision Structure

The If...Then Decision Structure