Excel 2007: VBA Programming

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