Excel VBA (Visual Basic) - Fundamentals
In collaboration with
-
13.12.2021
-
14 h
-
Formation présentielle
-
Formation à distance
-
Cours du jour
-
English
-
IF121CJ
*
(+3% TVA)Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus
Objectives
After the training the participant shall be able to:
program with Visual Basic (VBA) in Excel.
Programme
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
Prerequisites
Good Windows and Excel skills
Certificate
At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.
Lieu
-
Key Job S.A.65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg - Calculer l'itinéraire
Télécharger le planning PDF
7H
7H
lun. 13.12.2021 à 09h00
7H
Excel VBA (Visual Basic) - Fundamentals
-
Key Job S.A.
mar. 14.12.2021 à 09h00
7H
Excel VBA (Visual Basic) - Fundamentals
-
Key Job S.A.