Upon successful completion of this course, students will be able to:
* create recorded macros in Excel
* use the macro recorder to create a variety of    Macros
* create and work with user-defined functions
* work with the main components of the VBA Editor    window
* understanding the Excel object model and use the    Immediate window
* create command procedures
* create and use variables
* write code to manipulate Excel objects
* use a range of common programming techniques
* create a custom form complete with controls and    event procedures
* create code to drive a custom form
* customise the menu system
* create procedures that start automatically

Unit 1: Recorded Macros

* Setting Macro Security Levels
* Recording a Simple Macro
* Running a Recorded Macro
* Relative Cell References
* Running a Macro with Relative References
* Viewing a Macro Module
* Modifying a Recorder Macro

Unit 2: Recorder Workshop

* Preparing Data for an Application
* Recording a Summation Macro
* Recording Consolidations
* Recording Divisional Macros
* Testing Macros
* Creating Objects to run Macros
* Assigning a Macro to an Object

Unit 3: User-Defined Functions

* User-Defined Functions Theory
* Creating Simple User-Defined Functions
* Using User-Defined Functions
* Using Multiple Arguments
* Modifying a Function
* Creating a Function Library

Unit 4: Using The VBA Editor

* Opening and closing the Editor
* Working with the Project Explorer
* Working with the Properties Window
* Working with the Work Area
* Working with the Code Module
* Running Procedures from the Editor
* Setting Breakpoints in the Editor
* Stepping through a Procedure

Unit 5: Understanding VBA

* VBA terminology
* Accessing the Excel Object Model
* Using the Immediate Window
* Working with Object Collections
* Setting Property Values
* Working with Object Collections
* Setting Property Values
* Working with Worksheets
* Using the Object Browser
* Programming with the Object Browser

Unit 6: Procedures

* Creating a Command Procedure
* Making sense of IntelliSense
* Using the edit toolbar
* Commenting Statements
* Indenting Code
* Bookmarking in Procedures

Unit 7: Using Variables

* Creating & Using Variables
* Implicit and Explicit Declarations
* The Scope of Variables
* Procedure Level Scoping
* Module Level Scoping
* Passing Variables by Reference
* Passing Variables by Value
* Data Types
* Declaring Data Types
* Using Arrays

Unit 8: Using Excel Objects

* Applications Methods & Properties
* Workbook Methods & Properties
* Viewing Excel & the Editor together
* Using Workbook Objects
* Range Methods & Properties
* Using Range Objects
* Project - Using Objects in a Procedure

Unit 9: Programming Techniques

* The MsgBox Function
* Sending Messages to the User
* InputBox Techniques
* Using the InputBox Function
* Using the InputBox Method
* The IF statement
* Using IF for Single Conditions
* Using IF for Multiple Conditions
* The FOR NEXT Statement
* Looping with known or specified Iterations
* The DO LOOP Statement
* Looping with Unknown Iterations

Unit 10: Creating Custom Forms

* Creating a Custom Form
* Adding Text Boxes to A Form
* Changing Text Box Control Properties
* Adding Label Controls to a Form
* Adding a Combo Box Control
* Adding Option Buttons
* Adding Command Buttons
* Running a Custom Form

Unit 11: Programming Custom Forms

* Initialising a Form
* Closing a Form
* Project - Transferring Data From a Form
* Running Form Procedures
* Creating Error Checking Procedures
* Running a Form from a Procedure

Unit 12: Custom Menus

* Creating a New Menu
* Creating a Cascade Menu
* Adding Menu Commands
* Assigning Macros to Menu Commands
* Removing a Menu

Unit 13: Automatic Startup

* Programming Automatic Procedures
* Running Automatic Procedures
* Automatically Starting a Workbook