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.