Introduction to Macros

• What is a Macro? • Recording a Macro • Running a Macro • Relative References • Assigning a Macro to a Button on a Worksheet • Assigning a Macro to a Button on a Toolbar • Button Image Editor

Editing Macros

• The Visual Basic Editor • The Project Explorer • The Code Window • Procedures • Inserting Comments • Printing a Visual Basic Module

The Range Object

• What is the Range Object? • The Cells Property • The Range Property • Flexible Ranges • Range Contents

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

Variables and Constants Control Structures

• Conditional Control Structures • Looping Control Structures • Non-Structured Statements • Subprocedures

Controls, Dialogue Boxes and Forms

• Built-In Dialogue Boxes • Predefined Dialogue Boxes • Custom Forms • Worksheet Forms • Setting the Properties of a Control • User-Defined Forms • Adding Form Controls • Form Control Properties • Control and Dialogue Box Events • Displaying and Dismissing a User Form • Handling Form Controls

Toolbars and Display

• About Toolbars and Menus • Attaching Toolbars to Workbooks • Saving More Than One Toolbar Configuration • Customising Toolbars • Display Techniques

Debugging and Error Trapping

• What are Errors? • Types of Error • Break Mode • Instant Watch • Stepping Through Code • Error Handling Worksheet and Workbook Events

Function Procedures

• Function Procedures • User-Defined Functions • Function Wizard • Excel Functions

Add-in Applications

• What is an Add-in? • Creating an Add-In • Converting an Add-In to a Workbook