FR
EN
Details
Goals
Being able to program with Visual Basic (VBA) in Excel.
Prerequisite
Good Windows and Excel skills.
Contents
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
Sign up
Next session(s)
Mon.
28
Jul.
Tue.
29
Jul.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
18
Aug.
Tue.
19
Aug.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
18
Sep.
Fri.
19
Sep.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Thu.
09
Oct.
Fri.
10
Oct.
2025
Price will be €800 according to indexation on 05/01/2025 (effective as from July 1st)
Thu.
16
Oct.
Fri.
17
Oct.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
10
Nov.
Tue.
11
Nov.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
08
Dec.
Tue.
09
Dec.
2025
Price will be €800 according to indexation on 05/01/2025 (effective as from July 1st)
Tue.
16
Dec.
Wed.
17
Dec.
2025
Tarif de 800€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!