AJP IT Services

Course Objectives

This one day course gives an overview of Excel's programming language (VBA). The course will introduce the Visual Basic Editor screen (VBE), discuss the major programming concepts, cover error checking tools and enable users, through a workshop, to try out practical examples.

Who Should Attend?

Those who have advanced knowledge of Excel 2003 and who would like a broad overview of Excel's macro language. The course does not assume previous experience of macros although it would help if delegates have recorded some macros in the past. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Office Excel 2003 Advanced" course.

Course Contents

Using the Visual Basic Editor.

• Object Properties
• Methods
• Events
• The Object Browser

Data Types.

• Declaring Variables
• The scope of variables

Procedures.

Modules.

Functions.

• Creating a user defined function

Branches.

• Using If and Else
• Using Select Case

Loops.

• For/Next
• Do While/Loop

User Interaction.

• Message Boxes
• InputBox function
• Creating a User Form
• Attaching events to User Form buttons

Error Handling.

• Understanding different types of errors
• VBA debugging tools
• Breakpoints and Watch windows
• Stepping through code Handling errors

Workshop.

• Using examples to practice VBA techniques
• Option for users to create macros of their own choice