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 : 149.00 $
Preferential Rate : 126.65 $
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
14 Jun 2022 - 13:00 to 16:00

Virtual Class
7 Jul 2022 - 9:00 to 12:00

Virtual Class
4 Aug 2022 - 13:00 to 16:00