The VBA Applications for Excel class 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.

Target Audience: This course targets individuals interested in learning the basics of VBA Applications in Excel.

Table of Contents

Topic 1: Visual Basic Editor
Visual Basic for Applications
Object Programming
The Object Browser

Topic 2: Programming basics
Data
Scope of variables
Scope of procedures

Topic 3: Control structures
Decision structures
Loop structures

Topic 4: Custom dialog boxes
User forms
Events

Topic 5: Debugging and error-handling
Errors
Debugging
Error-handling

Prerequisite(s): A working knowledge of Excel