pds-it
['Product detail page','no']
Software development / VBA
The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration

VBA with Microsoft Office - Introduction to Office programming

Online
2 days
German
Download PDF
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36174
Venue
Online
5 dates
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36174
Venue
Online
5 dates
Become a certified
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training for your Employees only - exclusive and effective.
Inquiries
In cooperation with
Learn the fundamentals of Visual Basic for Applications (VBA) programming in Microsoft Office applications in this two-day training . The focus is on VBA in Excel, although other Office apps are also touched on.
Contents

1. introduction

  • Basic concepts
  • VBA use - When is VBA suitable?
  • Examples for the use of VBA
  • Security settings
  • The Visual Basic Editor

 

2. the macro recorder

  • The recording
  • Save macro
  • Analyzing a recorded macro
  • Execute a recorded macro
  • Fix errors, deactivate/skip lines of code

 

3. vba basics

  • Basic syntax in modules, procedures and functions
  • Upper and lower case
  • The key word WITH
  • Comments
  • Use of variables
  • Constants
  • Option Explicit
  • Naming conventions

 

4. even more VBA

  • Procedures
  • Functions
  • The MsgBox
  • The direct window
  • Local and global variables
  • Arrays or fields
  • IF...THEN...ELSE
  • SELECT...CASE
  • InputBox
  • Loops FOR...NEXT, WHILE...WEND, DO...LOOP
  • The Project Explorer

 

5. built-in VBA functions

  • Text functions
  • Date functions
  • Mathematical functions
  • Information functions
  • Convert data types

 

6. error handling

  • Handling runtime errors
  • Troubleshooting (debugging)
Your benefit
  • Optimal introduction to Office programming
  • Confident implementation of what you have learned thanks to a clear structure and systematic approach
  • Acquire solid basic knowledge
  • Translating workflows and processes into the VBA programming language in order to tap into a high level of automation potential
  • Mastering the VBA development environment and the most important tools for program creation and troubleshooting
trainer
Daniel Banholzer
Daniel Lisak
Methods

This course consists of training training and is led by a:m trainer who:supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.

Final examination
Recommended for

This course is aimed at power users, PC administrators and developers who want to get started with the automation of processes in Microsoft Office applications. No programming knowledge is required. Very good knowledge of Word and Excel is required.

Start dates and details

Form of learning

Learning form

17.6.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
28.8.2025
Online
Few places available
Implementation secured
Online
Few places available
Implementation secured
29.9.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
29.10.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
27.11.2025
Online
Few places available
Implementation secured
Online
Few places available
Implementation secured

The training is carried out in cooperation with an authorized training partner.

The latter collects and processes data under its own responsibility. Please take note of the corresponding privacy policy

Do you have questions about training?
Call us on +49 761 595 33900 or write to us at service@haufe-akademie.de or use the contact form.