Excel 2010:
VBA
Programming
Topic-Level Outline
Days: 1
Prerequisites: Excel
2010: Advanced
Unit 1: Visual Basic Editor
Topic A: Visual Basic for Applications
A-1: Discussing VBA
A-2: Preparing Excel for VBA
A-3: Examining the VBE window
Topic B: Object programming
B-1: Examining the Properties window
B-2: Changing an object’s 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: The Object Browser
C-1: Examining the Object Browser
C-2: Searching in the Object Browser
Unit 2: Programming basics
Topic A: Data basics
A-1: Discussing data types and variables
A-2: Declaring and discussing variables
A-3: Using operators
A-4: Using interaction functions
Topic B: Scope of variables
B-1: Understanding procedure- and module-level scope
B-2: Understanding public scope
Topic C: 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: 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: Loop structures
B-1: Using the For…Next loop
B-2: Using the For Each…Next loop
B-3: Using the Do While…Loop statement
Unit 4: Custom dialog boxes
Topic A: User forms
A-1: Adding a user form
A-2: Adding controls to a user form
Topic B: 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: Errors
A-1: Discussing the types of errors
Topic B: 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: Error handling
C-1: Using the On Error GoTo statement
C-2: Using the On Error Resume Next statement