Visual Basic for Microsoft Excel

Duration:

2 days.

Topics:

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

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