Office of Administration
 Matt Blunt, Governor - Larry Schepker, Commissioner
 
 
 

Information Technology Services

Excel 2003 with VBA

Duration:

One day

Table of Contents

Unit 1: Visual Basic Editor

Topic A: Visual Basic for Applications

Topic B: Object Programming

Topic C: The Object Browser

Unit 2: Programming basics

Topic A: Data

Topic B: Scope of variables

Topic C: Scope of procedures

Unit 3: Control structures

Topic A: Decision structures

Topic B: Loop structures

Unit 4: Custom dialog boxes

Topic A: User forms

Topic B: Events

Unit 5: Debugging and error-handling

Topic A: Errors

Topic B: Debugging

Topic C: Error-handling

Scheduled Classes