Capital Business Machines Excel 2007 VBA Programming – Level 5

Excel 2007: VBA Programming

Excel 2007 Visual Basic for Applications is designed to give proficiency in creating procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Days:

1 day

Prerequisites:

Excel 2007: Advanced

Course Outline

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