Introduction to VBA for MS Excel

2 Days

Recording macros
Recording - Absolute / Relative
Using Macro Buttons

Selecting cells
Relative / Absolute Selections
Selecting Range

Visual Basic Editor
Navigating the Project Explorer
Creating modules
Fundamentals of a module

VB Concepts
Declaring Variables / Constants
Option Explicit
Scope

The Excel Object Model
Objects and collections
Methods and properties

VB Techniques
Conditional statements
Loops
Functions

Events
Assigning a macro to an event
Canceling an event

Events
Assigning a macro to an event
Canceling an event  

Debugging
The immediate window
Setting breakpoints
Error handling

Working with Forms and Pop-ups
Creating forms
Form Interaction
Opening / closing
Message boxes
Input boxes

Interacting with other applications
What is an API ?
API References
Linking to other MS Office Applications
Working with other files

Questions & Answers