Excel VBA part 1 | Virtuel classroom

Course Overview

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

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
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 - 9:00 to 12:00

Virtual Class

23 Jul 2024 - 9:00 to 12:00

Virtual Class

19 Sep 2024 - 9:00 to 12:00

Virtual Class

4 Nov 2024 - 9:00 to 12:00