Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus
En collaboration avec:
Description
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
Modalités
Support de cours
Le support de cours sera délivré en début du cours.
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.
Calculer l'itinéraire
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
L-1611 Luxembourg
Luxembourg