Unit 1: Visual Basic Editor

Topic A: Visual Basic for Applications

·        Discussing VBA

·        Preparing Excel for VBA

·        Examining the VBE window

Topic B: Object programming

·        Examining the Properties window

·        Changing the object properties

·        Using code to change object properties

·        Using a method

·        Associating VBA code with an event

·        Executing VBA code by using a button

Topic C: The Object Browser

·        Examining the Object Browser

·        Searching in the Object Browser

Unit 2: Programming basics

Topic A: Data basics

·        Discussing data types and variables

·        Discussing and declaring variables

·        Using operators

·        Using the interaction functions

Topic B: Scope of variables

·        Understanding procedure- and module-level scope

·        Understanding public scope

Topic C: Scope of procedures

·        Creating a Sub procedure

·        Calling a Sub procedure

·        Creating a Function procedure

·        Calling a Function procedure

Unit 3: Control structures

Topic A: Decision structures

·        Using the If…Then statement

·        Using the If…Then…Else statement

·        Using the If…Then…ElseIf statement

·        Using the Select Case statement

Topic B: Loop structures

·        Using the For…Next loop

·        Using the For Each…Next loop

·        Using the Do While…Loop

Unit 4 : Custom dialog boxes

Topic A: User forms

·        Adding a user form

·        Adding controls to a user form

Topic B: Events

·        Attaching an event handler to a control

·        Validating data by using event handlers

Unit 5 : Debugging and error handling

Topic A: Errors

·        Discussing types of errors

Topic B: Debugging

·        Discussing debugging tools

·        Setting a breakpoint

·        Adding a watch expression

·        Using Step Into

·        Deleting a watch expression

·        Working with the Immediate window

·        Working with the Locals window

Topic C: Error handling

·        Using the On Error GoTo statement

·        Using the On Error Resume Next statement