Excel VBA Programming Course 2003

Also known as Excel Visual Basic for Applications Course 2003

Quick Links to Other Excel Courses

1. Microsoft Excel Basic Course
2. Microsoft Excel Intermediate Course
3. Microsoft Excel Advanced Course

Duration:

2 days

Prerequisites:

Excel 2003 : Advanced or equivalent experience

• Record Absolute and Relative Macros

• Assign Marcos to a Button

• Create a Custom Function to Perform a Calculation

• Call a Function from a Worksheet

• Call a Function from a Macro

• Visual Basic for Applications

• Working with Objects, Properties, Methods, and Events

• Use the Immediate window

• Understand the Object Model

• Using the Object Browser

• Working with data

• Using Variables

• Understanding Scope

• Using Decision Structures

• Using Loop Structures and their Variations

• Creating custom dialog boxes (Userforms)

• Handling events

• Programming Custom Dialog Boxes

• Create a Macro to Run Automatically on Start up

• Create a Custom Menu for a Project

• Customise the Menu System

• Errors in Code

• Using Debugging Techniques

• Error-handling