Excel VBA (Visual Basic) - Fundamentals

Interface

Terminology

• Key Words

• Description of an object in VBA

Recording

• Recording procedure

• Recording options

• Manual execution of a macro

Creating a procedure –Subroutine

• Inserting new modules

• Inserting a new procedure or function

• Help in the creation process

The variables

• Variables accessibility

• The “Dim as” statement

References and Selections

• Cell references

• Object references

• Selection of a cell or of an object

Interactivity

• Inputbox

• Msgbox

Conditions

• The “IF” Statement

• The “Select Case” Statement

Loops

• For…Next

• Do…Loop

Object manipulations

User Forms

Debugger

• Step by step execution

• Break point

• Watch-Immediate window

Functions

Managing errors codes