Course Overview
Using Visual Basic programming language. Create dialog boxes or elements that interact with the user.
Excel VBA part 2 | Virtuel classroom
Prerequisites
VBA part 1
Syllabus
Introduction to VBA Part 2:
- Defining control structures;
- Using conditional instructions, loops and logical operators in expressions;
- Working with the object explorer and managing errors;
- Using the Screen Updating function;
- Using the With instruction;
- Working with the object explorer;
- Managing errors;
- Using Excel and VBA functions in procedures;
- Entering a formula inside a cell;
- Creating and using a custom function;
- Diverse and interesting procedures;
- Adding the file path in the footer;
- Using switching procedures;
- Reaching an address and activating it in the upper left corner of the window;
- Learning procedures to work with a range of cells.
Dialog Boxes:
- Working with dialog boxes;
- Creating and using a user interface;
- Placing controls on a sheet;
- Working with controls on a sheet;
- Formatting controls;
- Using additional controls;
- Working with the code associated to events;
- Identifying events;
- Initializing dialog boxes;
- Writing event-driven procedures for controls inside a dialog box.
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.