Introduction

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

Assigning Macros to Buttons and Objects

• Assigning a Macro to a Button or a Drawn Object on a Sheet
• Assigning a Macro to a Button on a Toolbar
• Customising a Toolbar
• Creating a Toolbar
• Button Image Editor
• Changing a Button's Screen Tip

Editing Macros

• Visual Basic Editor
• Project Explorer
• Procedures; Inserting Comments
• Printing a Visual Basic Module

The Range Object

• Cells & Range Method; Flexible Ranges
• Virtual Worksheet's; Range Contents

Workbooks and Sheets

• Activating a Workbook & Worksheet

Objects, Properties &  Methods

• Controlling Objects with their Properties
• Performing Actions with Methods
• Performing Multiple Actions on an Object

Variables and Constants

• Variables, Data Types & Constants

Control Structures

• Conditional & Looping Control Structures
• Non-Structured Statements
• Sub Procedures

Controls Dialogue Boxes and Forms

• Built-In & Predefined Dialogue Boxes
• Custom, Worksheet & User Defined Forms
• Adding Form Controls
• Form Control Properties
• Control & Dialogue Box Events
• Displaying & Dismissing a User Form

Storing Information

• The Windows Registry

Toolbars &  Display

• About Toolbars & Menus
• Customised Menus
• Display

Debugging &  Error trapping

• Errors, Break Mode; Instant Watch
• Stepping & Error Handling

Worksheet & Workbook Events

• Worksheet Object Events
• Workbook Object Events

Function Procedures

• User Defined Functions

Appendix A  - Naming Conventions

• User Form Controls
• Memory Variables