Excel 2003:
VBA Programming

Topic-Level Outline

             Days:           1

Prerequisites:           Excel 2003: Advanced

             Unit 1 :           Visual Basic Editor

           Topic A: 0   Visual Basic for Applications

           A-1:           Discussing VBA

           A-2:           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

           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