Excel 2010:
VBA Programming

Topic-Level Outline

                         Days:  1

          Prerequisites:  Excel 2010: 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 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: 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:                               Declaring and discussing variables

                               A-3:                               Using operators

                               A-4:                               Using 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 statement

                         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 the 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