Back to Search Results

Training Course Summary:

This class is designed for delegates who want to become acquainted with VBA concepts, record, edit and assign procedures to menus and objects, use function procedures, objects, properties, methods and interactive procedures, control and automate procedures, customise menus and command bars and create user forms.

Pre-Requisites:

To gain maximum benefit from this course delegates should be able to demonstrate the following skills:

Completion of Excel 97 Advanced

Training Course Overview/Content:

At course completion, delegates will be able to:

Describe the concepts in and uses of Visual Basic for Applications
Record and edit basic procedures
Debug Visual Basic code
Assign procedures to menus, objects and keyboard shortcuts
Use function procedures
Use objects, properties and methods
Use interactive procedures
Control procedures
Automate procedures
Customise menus and command bars
Create user forms