Microsoft Excel 2010:  VBA Programming

Length: 1 day
Software Version:  2007/2010
Prerequisites: Excel 2010 knowledge, including how to create, edit, format, and print worksheets that include sorted and filtered data is required. You should also know how to write and edit simple formulas. 

Target Student:  This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
 

Course Content

Lesson 1: Visual Basic Editor
Visual Basic for Applications
Object programming
The Object Browser

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

Lesson 3: Control structures
Decision structures
Loop structures

Lesson 4: Custom dialog boxes
User forms
Events

Lesson 5: Debugging and error handling
Errors
Debugging
Error handling 

BACK