Course series

Excel VBA Programmierung Grundlagen - Microsoft Office Training

With the help of the VBA programming language available in Excel, recurring work steps can be made easier and complex tasks can be automated.

Advanced 24:00 hrs. English

1.368,50 €

incl. VAT

1.150,00 € (net)

Already on the waiting list The appointment is fully booked

Description

Seminar content
Introduction

What does VBA mean?
Linking VBA procedure with menu bar

Working with the VBA development environment

Project Explorer
Properties window
Module window
Direct window
Local window

The language elements of VBA

Using modules
Programming procedures
Variables, constants and their data types
Controlling program flow with control structures
Predefined functions

Object-oriented programming with VBA

What are objects ?
Object hierarchies (object models)
Properties and methods of objects
Object variables
Object catalog

Shared VBA elements

VBA elements for all Office applications
Programming the application window
Programming the document window
Programming the file system
Input dialogs and message windows

Aim

/

Participant requirements

Good knowledge of Microsoft Office Excel

Participant

Microsoft Office Excel user

Upcoming courses

Providers

Vertrieb EDC

Free places

12

Training

Date

Title

9/13/21 9:00 AM - 5:00 PM

Tag 1

9/14/21 9:00 AM - 5:00 PM

Tag 2

9/15/21 9:00 AM - 5:00 PM

Tag 3


You might also be interested in

Report problem


Thanks

for your interest in this product.

We will get in touch with the provider immediately and will offer new dates shortly.
We will inform you about the new dates in 14 days at the latest.

Until then you will find the product in your wish list.