Basic Macro Concepts

Macros And Sub Procedures

Limitations Of Recorded Macros

Recording Macros

Relative Referencing

Macro Options

Storing Macros

Editing A Macro

Debugging A Macro

Step Into, Step Over, Step Out

Run To Cursor

Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.

Visual Basic

Defining Projects, Modules, Sub Procedures, Statements, And Events

The Visual Basic Editor

Views And Icons

Adding Comments

Checking Syntax Errors

Sub Procedures

Structures Of Sub Procedures

Objects

Working With

Object Names

Class

Properties

Common Properties

Using The With Command

Properties That Are Objects

Methods

Common Methods

Events

The Object Browser

Project/Library Box

Classes

Variables

Constants

Variable Types

String Variables

Date Variables

Declaring Several Variables

User Interaction

Input Boxes

Converting Input Box Answers

Message Boxes

Building Messages

Special Characters To Sue When Concatenating

Message Box For Input

Status Bar Messages

Flow Of Control

If … Then Statements

If  … Then … Elseif

Running Other Procedures From Within Procedures

If Statements With Message Boxes

For … Next Loops

Do While … Loops

Event Trapping

Auto_Open And Auto_Close

On Error Go To

Resume

Application Event Properties

Other Objects’ Event Properties

Working With Other Programs

Opening / Sending Commands To

Linking Up With Libraries