Course Overview
Using Visual Basic programming language. Create dialog boxes or elements that interact with the user.
Excel VBA part 1 | Virtuel classroom
Prerequisites
Create macros using the macro recorder
Syllabus
Introduction to VBA
Part 1: Why use VBA?
- Opening the VBA editor;
- Defining the properties of objects;
- Notions required to learn VBA;
- Creating a procedure;
- Creating a sub-procedure and writing code;
- Using online help;
- Using objects;
- Using the Application, Workbook, Worksheet and Range as well as the Sheets objects;
- Defining variables and constants;
- Defining variables and constants;
- Identifying the span of variables and constants;
- Applying the Explicit option;
- Using information box functions;
- Defining the Function procedures.
Why create custom functions?
Duration : 3 h
Note :
Regular Rate :
179.00 $
Preferential Rate : 152.15 $Note :
Webinar Web Platform
Access available 15 minutes before the Webinar.
The access instructions and the password will be provided by email 48 hours before the presentation.
NEXT DATE(S)
Related trainings
Next Date :
Duration : 3 h 00
Locations : Classe virtuelle
Next Date :
Duration : 2 Days
Locations : Laval, Classe virtuelle, Montréal
Next Date :
Duration : 3 h
Locations : Classe virtuelle