VBA For Excel Training

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
Running Code
Run mode and Design mode
Running Code from the development environment
Running Code from the host application
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 Formular 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