Excel Macros with VBA - 1 Day

Introduction to Microsoft Excel Macros and VBA
The Microsoft Excel Macro Recorder
Recording a Macro
A Practical Example
Playing a Macro
Absolute and Relative Recording
Deciding between Relative VS Absolute Referencing
Making Your Macros Accessible
Adding Buttons to your Worksheet

Adding Controls from the Forms Toolbar

Adding Controls from the Control Toolbox Toolbar

Custom Toolbars
A Peak into the world of VBA Programming
The Visual Basic Editor
Code Procedures and Modules

The Project Explorer
The Properties Window
Updating a Recorded Macro
Creating User Defined Functions
Programming Microsoft Excel with VBA and more

UDF's
Direct Reference to Ranges
What UDFs cannot do and some other tips
The Microsoft Excel Object Model
Microsoft Excel Objects
Microsoft Excel Collections
Microsoft Excel VBA Object Properties
Microsoft Excel VBA Object Methods
The Microsoft Excel VBA Object Browser
Experimenting in the Immediate Window