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 icon 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 Icon

• Adding a Button to the Quick Access Toolbar

• Assigning an image to a Macro Toolbar Button

Visual Basic Tips and Techniques

• Using Copy and Paste procedures

• Dealing with Errors

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

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

© Copyright The Fourth R^®