Objectives of the VBA language
Presentation of VBA
Some definitions
Use of VBA
Principle of operation of a macro

Modifying the code of a macro
Language syntax
Variables
Arrays
Constants
Operators

The Application object
The Workbook object
The Worksheet object

The Range object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Synthesis
Questions / Answers

Review of the important elements Revisions before certification
Passing of the TOSA certification on Excel