Excel 2007:
VBA Programming

Topic-Level Outline

Days: 1

Prerequisites: Excel 2007: Advanced

Unit 1 : Visual Basic Editor

Topic A: 0 Visual Basic for Applications

A-1: Discussing VBA

A-2: Preparing Excel for VBA

A-3: Examining the VBE window

Topic B: 0 Object programming

B-1: Examining the Properties window

B-2: Changing the object properties

B-3: Using code to change object properties

B-4: Using a method

B-5: Associating VBA code with an event

B-6: Executing VBA code by using a button

Topic C: 0 The Object Browser

C-1: Examining the Object Browser

C-2: Searching in the Object Browser

Unit 2 : Programming basics

Topic A: 0 Data basics

A-1: Discussing data types and variables

A-2: Discussing and declaring variables

A-3: Using operators

A-4: Using the interaction functions

Topic B: 0 Scope of variables

B-1: Understanding procedure- and module-level scope

B-2: Understanding public scope

Topic C: 0 Scope of procedures

C-1: Creating a Sub procedure

C-2: Calling a Sub procedure

C-3: Creating a Function procedure

C-4: Calling a Function procedure

Unit 3 : Control structures

Topic A: 0 Decision structures

A-1: Using the If…Then statement

A-2: Using the If…Then…Else statement

A-3: Using the If…Then…ElseIf statement

A-4: Using the Select Case statement

Topic B: 0 Loop structures

B-1: Using the For…Next loop

B-2: Using the For Each…Next loop

B-3: Using the Do While…Loop

Unit 4 : Custom dialog boxes

Topic A: 0 User forms

A-1: Adding a user form

A-2: Adding controls to a user form

Topic B: 0 Events

B-1: Attaching an event handler to a control

B-2: Validating data by using event handlers

Unit 5 : Debugging and error handling

Topic A: 0 Errors

A-1: Discussing types of errors

Topic B: 0 Debugging

B-1: Discussing debugging tools

B-2: Setting a breakpoint

B-3: Adding a watch expression

B-4: Using Step Into

B-5: Deleting a watch expression

B-6: Working with the Immediate window

B-7: Working with the Locals window

Topic C: 0 Error handling

C-1: Using the On Error GoTo statement

C-2: Using the On Error Resume Next statement