New
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 : 129.00 $
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
15 Dec 2020 - 9:00 to 12:00

Virtual Class
20 Jan 2021 - 13:00 to 16:00

Virtual Class
18 Feb 2021 - 9:00 to 12:00

Virtual Class
2 Mar 2021 - 13:00 to 12:00

Virtual Class
3 May 2021 - 9:00 to 12:00

Virtual Class
2 Jun 2021 - 13:00 to 16:00

Virtual Class
5 Jul 2021 - 9:00 to 12:00

Virtual Class
13 Aug 2021 - 9:00 to 12:00

Virtual Class
13 Sep 2021 - 13:00 to 16:00