Excel: Programming with VBA
Overview: Students will examine the basics of customizing their
workbooks with macros written in VBA code.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction,
Excel Level 2
Table of Contents
Unit 1 : Using Visual Basic EditorTopic A: Visual Basic for Applications
A-1:Discussing VBA
A-2:Examining the VBE window
Topic B: Working with objects, properties, methods, and events
B-1: Examining the Properties window
B-2: Modifying the properties of an object
B-3: Using code to change object properties
B-4: Using a method
B-5: Associating VBA code with an event
Topic C: Using the Object Browser
C-1: Examining the Object Browser
C-2: Searching in the Object Browser
Unit 2 : Programming basics
Topic A: Working with 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: Understanding scope
B-1: Examining the Code window
B-2: Understanding procedure- and module-level scope
B-3: Understanding Public scope
B-4: Creating a Sub procedure
B-5: Calling a Sub procedure
B-6: Creating a Function procedure in a standard module
B-7: Calling a Function procedure
Unit 3 : Controlling program flow
Topic A: Using 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: Using 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 : Working with custom dialog boxes
Topic A: Creating custom dialog boxes
A-1: Adding a user form
A-2: Adding controls to a user form
Topic B: Handling events
B-1: Attaching an event handler to a control
B-2: Validating data using event handlers
Unit 5 : Debugging and error-handling
Topic A: Errors in code
A-1: Discussing types of errors
Topic B: Using debugging techniques
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: Using the Locals window
Topic C: Error-handling
C-1: Writing error-handling code