Excel 2000:
VBA Programming

Topic-Level Outline

Days: 1

Prerequisites: Excel 2000: Basic, Intermediate, and Advanced or equivalent experience

Unit 1 : Using Visual Basic Editor

Topic A: 0 Visual Basic for Applications

A-1: Discussing VBA

A-2: Examining the VBE window

Topic B: 0 Working with objects, properties, methods, and events

B-1: Examining the Properties window

B-2: Modifying the properties of an object

B-3: Using code to change object properties

B-4: Using a method

B-5: Associating a VBA code with an event

Topic C: 0 Using the Object Browser

C-1: Examining the Object Browser

C-2: Searching in the Object Browser

Unit 2 : Programming basics

Topic A: 0 Working with data

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 Understanding scope

B-1: Examining the Code window

B-2: Understanding procedure and module-level scope

B-3: Understanding Public scope

B-4: Creating a Sub procedure

B-5: Calling a Sub procedure

B-6: Creating a Function procedure in a standard module

B-7: Calling a Function procedure

Unit 3 : Controlling program flow

Topic A: 0 Using 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 Using 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 : Working with custom dialog boxes

Topic A: 0 Creating custom dialog boxes

A-1: Adding a user form

A-2: Adding controls to a user form

Topic B: 0 Handling events

B-1: Attaching an event handler to a control

B-2: Validating data using event handlers

Unit 5 : Debugging and error-handling

Topic A: 0 Errors in code

A-1: Discussing types of errors

Topic B: 0 Using debugging techniques

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: Using the Locals window

Topic C: 0 Error-handling

C-1: Writing error-handling code