Proficient knowledge of Excel 2000 or Excel 97. Advanced knowledge of PivotTables helpful but not required.

Topics

Getting Started

Introducing Visual Basic for Applications

Recording a Macro

Running a Macro

Understanding the VB Editor

Using the Menu Bar

Using the Standard Toolbar

Using the Project Explorer

Using the Properties Window

Understanding the Code Window

Understanding Code Window Options

Editing Code

Getting Help

Closing the Visual Basic Editor

Introducing Objects

Understanding the Object Browser

Understanding Objects

Understanding the Object Hierarchy

Referencing Objects

Understanding Collections

Using the Editing Features

Using the Immediate Window

Using the Auto List

Using Auto Quick Info

Introducing Variables

Understanding Variables

Declaring Variables

Understanding Data Types

Storing Values in Variables

Storing Objects in Variables

Creating Procedures and Functions

Understanding Procedures

Using the Macro Recorder to Create Sub Procedures

Calling Procedures from Procedures

Using Intrinsic Functions

Using Message Boxes

Using Input Boxes

Creating Functions

Passing Arguments to a Function

Working with Conditional Statements

Understanding Conditional Statements

Working with Decision Structures

Working with Looping Structures

Working with Forms and Controls

Understanding UserForms

Using the Toolbox

Working with UserForm Properties, Events, and Methods

Using the Properties Window

Understanding Controls

Working with the Label Control

Working with the Text Box Control

Working with the Command Button Control

Working with the Combo Box Control

Working with the Frame Control

Working with Option Button Controls

Adding Functionality to Forms

Working with Control Appearance

Setting the Tab Order

Populating a Control

Adding Code to Controls

Launching Forms from Procedures

. Using PivotTables

Understanding PivotTables

Creating PivotTables

PivotTable Arguments

Adding Fields to PivotTables

Controlling Forms

Controlling PivotTables from a Form

Controlling a Form from a Custom Toolbar

Understanding Debugging

Understanding Errors

Debugging Code

Debugging Tools

Using the Locals Window

Using the Watch Window

Using Breakpoints