Excel 2010: VBA Programming

COURSE OUTLINE:

Description This instructor-led 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.

Prerequisites
Recommended for advanced-level Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Course Content


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 basics
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