New
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 : 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
14 Dec 2020 - 13:00 to 16:00

Virtual Class
19 Jan 2021 - 9:00 to 12:00

Virtual Class
17 Feb 2021 - 13:00 to 16:00

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

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

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

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

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

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

Virtual Class
10 Sep 2021 - 9:00 to 12:00