Excel 2000: VBA Programming

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.

Audience

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

Skills Gained

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

Prerequisites

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