Excel VBA Training

1. Excel 2003 VBA - $395 (1 day - instructor-led)

This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

• To work with Object Properties and Methods
• Attach code to events and buttons
• Using Variables, Procedures and Functions in VBA
• Control Structures to execute code
• Add User Forms and Controls
• Validate User entries
• Error handling and debugging

• Visual Basic Termimology
• Start the Visual Basic Editor
• Work with Object properties and methods
• Attach code to events and buttons
• Use Object Browser to get information about Objects

• Use Variables of various Data Types
• Manipulate Data using Expressions
• Declare and use Variables of correct Scope
• Declare and use Procedures of correct Scope
• Create Sub and Function Procedures
• Call one Procedure from other

• Use Decision Structures to create procedures that execute code
• Use Loop structures to execute code repeatedly

• Add a User Form to your project
• Add Controls to User Form
• Attach Handle Events to Controls
• Validate Data entered

• Identify compile-time, run-time and logical errors
• Use the Debugging Tools
• Write Error-handling code to trap errors