Objectives
After completing the course, participants will be able to:

• Record, edit and run personal and workbook macros

• Use absolute and relative references in Macros

• Create a macro toolbar and add a macro button to a worksheet

• Display Data Prompts

• Use a conditional statement and a control loop in a macro

• Place a drop-down list box and a check box on a worksheet

• Use Visual Basic to Write Macros

What you will learn
Topics covered by this course include:

Creating and Using Personal Macros

• Recording & Running a Personal Macro

• Displaying Macro Instructions

• Editing a Macro

• Using Absolute & Relative References

Creating and Using Workbook Macros

• Recording & Running a Workbook Macro

• Adding a Macro Button to a Worksheet

Using Visual Basic to Write Macros

• Opening a New Module in the Visual Basic editor

• Displaying a Data Prompt

• Using a Conditional Statement

• Using a Control Loop in a Macro

• Additional Control Statements

Placing Controls on a Worksheet

• Placing a Combo Box List and Check Box on a Worksheet / Linking a Control to Data

Creating a Macro Toolbar

• Creating a New Toolbar

• Adding a Button to a Toolbar

• Assigning a Macro to a Toolbar Button

Creating a Macro Menu

• Creating a New Menu

• Adding an Item to a Menu / Assigning a Macro to a Menu Item

Using the Visual Basic Help System

• Displaying Visual Basic Help information

Prerequisites
Course participants should have completed Excel 2003 Part 3 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®