Excel VBA (Visual Basic) - Fundamentals

Good Windows and Excel skills

After the training the participant shall be able to:

• program with Visual Basic (VBA) in Excel.

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

At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.