Microsoft Excel 2000 VBA Developer

Introduction

What is a Macro?
Recording a Macro
Running a Macro
Relative References

Assigning Macros to Buttons and Objects

Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Button on a Toolbar
Exercise 1

Editing Macros

Visual Basic Editor
Procedures
Inserting Comments
Printing a Visual Basic Module
Exercise 2

The Range Object

Introduction
Cells Property
Range Property
Flexible Ranges
Range Contents
Exercise 3

Workbooks and Sheets

Activating a Workbook
Activating a Worksheet
ThisWorkBook

Objects, Properties and Methods

Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple actions on an Object
Exercise 4

Variables and Constants

Variables
Data Types
Constants
Exercise 5

Control Structures

Conditional Control Structures
Looping Control Structures
Non-Structured Statements
Sub Procedures
Exercise 6

Controls, Dialog Boxes and Forms

Introduction
Built-In Dialog Boxes
Predefined Dialog Boxes
User-Defined Forms
Worksheet Forms
Visual Basic Forms
Handling Form Controls
Exercise 7

Storing Information

The Windows Registry
Settings Files

Toolbars and Display

About Toolbars and Menus
Customised Toolbars
Display Techniques
Exercise 8

Debugging and Error trapping

Errors
Break Mode
Instant Watch
Stepping
Error Handling
Error Handling Example

Worksheet and Workbook Events

Worksheet Object Events
Workbook Object Events

Function Procedures

Introduction
User-Defined Functions
Exercise 9

Add-in Applications

Creating an Add-In
Converting an Add-In to a Workbook
Exercise 10

Appendix A Naming Conventions

User Form Controls
Memory Variables