Microsoft Office Macro Programming
Using Visual Basic for Applications

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led course, through lecture and hands-on exploration, will introduce students to the Microsoft Office macro programming environment and show students how to use Visual Basic for Applications to create more complex macros. Microsoft Excel is used as the platform for this course, although the concepts apply across the entire Microsoft Office suite.

Prerequisites

It is strongly recommended that students have a strong familiarity with Microsoft Excel prior to taking this course.

Is this the right course for you? Please contact our office at 202.682.4500 if you have any questions.

Introduction to Visual Basic for Applications

Running a Macro

Recording a Macro

Examining Module Design

Assigning Macros

Specifying the Location of Recorded Macros

Assigning Macros to Menus, Buttons, and Toolbars

Creating Decision-Making Code

The If...Then Decision Structure

The If...Then...Else Decision Structure

The Select Case Decision Statement

Using Loop Structures

Using a For...Next Statement

Using a Do...Loop Statement

Using a For Each...Next Statement

Macro Management

Personal Macro Workbook

Assigning Sub Procedures to Run Automatically

Recording a Macro in Word

Running a Macro

Recording a Macro

Interactive Macros

Creating a Custom Message Box

Creating a Custom Input Box

Extracting Data from Excel