Excel VBA part 2 | Virtuel classroom

Course Overview

Using  Visual Basic programming language. Create dialog boxes or elements that interact with the user.

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
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.



Upcoming Dates

qty

Virtual Class

6 May 2024 - 13:00 to 16:00

Virtual Class

24 Jul 2024 - 9:00 to 12:00

Virtual Class

19 Sep 2024 - 13:00 to 16:00

Virtual Class

4 Nov 2024 - 13:00 to 16:00