Microsoft Excel 2000: Visual Basic for Applications (VBA) Programming UK Classes & Lessons (Microsoft)

About this class

This class is designed to help delegates describe the concepts in and uses of Visual Basic for Applications, record and edit procedures, debug visual basic code, assign procedures to menus, objects, and keyboard shortcuts, use function procedures and objects properties and methods. In addition, delegates will learn to use interactive procedures, control procedures, automate procedures, customise menus and command bars and create user forms.

Who will the lesson benefit?

Professionals who use WordPerfect for legal documentation and publishing solutions would find this course beneficial.

What delegates will learn

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

What prerequisites are required

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

Completion of Windows 95/98 Introduction, New Features, or a working knowledge of Windows 95/98
Completion of Excel 2000 Advanced