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