Excel VBA Programmierung Grundlagen - Microsoft Office Training

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