VBA for Excel

Creating Record Macros
Recording a Macro Running a Macro Running a Macro from the Macros Dialog Box Creating a Short-cut key to run a macro Running a Macro with a Shortcut key Assigning a Macro to a Menu or Toolbar Editing a Macro with Visual Basic

Visual Basic Editor
Objects
Methods
Properties
Programming Tools
The Menu Bar

The Project Explorer
Using the Project Explorer

The Properties Window
Changing a Property

Using Constants
Excel Constants
Variable Constants

Excel Objects
Objects, Properties and Methods
Getting & Setting Properties
Calling Methods
Passing Arguments
Singular Objects & Collections of Objects

Variables
Dimensioning a variable
Using variables in routines
Object Variables

Using Visual Basic Functions
InputBox Function
MsgBox Function
Using a Set Statement

Building Formulae

Control Structures
If…Then Decision Structures
Logical Operators
Select Case
Decision Structures Case Else Comparison Operators with Select Case Structure For… Loops Do Loops While...Wend Statement

UserForms
Designing & Creating Forms
Working with Controls
Creating Custom Dialog Boxes
Userform Properties
Methods & Events

Event Handling
VBA Editing & Debugging Auto Macros
Error Handling