Declaring and Using Variables and Constants
Variable types
Scope
Option Explicit

Creating Advanced User Forms
The RefEdit control
Multipage & Multitab controls
Combo & List box controls
Spinners
Scroll bars

The Personal Macro Workbook

Introduction to Excel’s object model

Error Trapping
On Error Resume Next
On Error branch
Handling the Find and Goto command errors

Debugging

Defining and Using VBA Arrays

The Select Case command

The VBA window
The VBA Toolbars
The Immediate window
The Locals window
The Watches window
The Object browser
Useful Menu commands
VBA Project Properties & Options

Some important Events
Events on user forms
Events in the workbook and worksheet
The OnTime and OnKey event

Creating XLA files – Excel Add-ins
 

Using Spreadsheet and VBA Functions in VBA

Custom Functions (optional)

Developing a student requested application (optional depending on time)

Understanding Class Modules (Optional)

Appendix I – Speeding Up Your Code Execution

Appendix II – VBA Code for Selecting

Appendix III – Working With Protected Documents in VBA