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

Using Constants

• Excel Constants
• Variable Constants

Excel Objects

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

Using Visual Basic Functions

• InputBox Function
• MsgBox Function
• Using a Set Statement

Building Formular Control Structures

• If Then Structures
• Logical Operators
• Select Case Janision Structures
• Case Else
• Comparison Operators with Select Case Structure
• For Loops
• Do Loops
• While...Wend Statement

Running Code

• Run mode and Design mode
• Running Code from the development environment
• Running Code from the host application

The Properties Window

• Changing a Property

Variables

• Dimensioning a variable
• Using variables in routines
• Object Variables

Userforms

• Designing & Creating Forms
• Working with Controls
• Userform Properties Methods & Events

Advanced VBA Programming Techniques

• Developing Excel Utilities with VBA
• Error Handling
• Using In-Built Excel Features in VBA
• Working with Pivot Tables
• Working with Charts
• Understanding Excel's Events
• Interacting with Other Applications
• Creating and Using Add-Ins