En collaboration avec:
Description
Description
This course enables you to master the fundamentals of VBA programming in Excel to automate repetitive tasks, create custom interfaces, and optimize your workflows. You will learn how to record and edit macros, manipulate Excel objects through code, use conditional structures and loops, create functions and user forms, and debug your programs. With a hands-on approach, you will develop practical skills to increase your efficiency and autonomy when working with Excel.
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
Conditions
Course Material
The training material will be handed out at the beginning of the course.
Certificate
At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.
Location
L-1611 Luxembourg
Luxembourg