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 Excel - The training for advanced users

Online
2 days
German
Download PDF
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36175
Venue
Online
3 dates
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36175
Venue
Online
3 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
This two-day training is aimed at user:in and developers who have a basic knowledge of VBA and want to further automate tasks and processes in Excel. You will learn many methods for automating your Excel workbooks.
Contents

1. the Excel object model

  • The object hierarchy
  • The most important Excel objects
  • The most important enumeration objects
  • References to the active element

2. working with cells and areas

  • Cell and area addressing
  • The Range object
  • The Cells method

3. working with tables and workbooks

  • Addressing tables and workbooks
  • Managing workbooks

4. error handling

  • Catching errors
  • Using Visual Basic test aids

5. event-controlled programming

  • Event procedures on the table and workbook levels
  • Auto macros

6. automation with Excel

  • Simple controls
  • ActiveX controls
  • Calling up and controlling Excel and dialog windows
  • Save user settings in the registry
  • Merge data from multiple tables
  • String functions

7. forms

  • Use of UserForms
  • Definition and programming of control elements in forms
  • Importing data into forms
  • Save form data

8. text files

  • Differentiate between types of text files
  • Reading and writing text files
  • Importing text files into Excel spreadsheets

9. improvement of runtime and program stability

  • Screen refresh
  • Control of the recalculation

10. tips and tricks from the field

Your benefit
  • Deepen your VBA knowledge in Excel
  • Create your own formulas and dialogs
  • Programming the fully automatic creation of reports 
  • Confident and independent solution of applications from daily practice with VBA in Excel 
  • Understanding of the Excel object model
  • Stable and secure implementation of your programs 
trainer
Daniel Lisak
Jörn Schramm
Methods

This course consists of training training and is led by a 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

Power users, user:in and developers who work with Excel, already have previous knowledge of VBA and would now like to deepen their knowledge of Excel programming. No VBA basics are taught in this course. Very good knowledge of Excel and VBA is required.

Start dates and details

Form of learning

Learning form

8.7.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
6.10.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
1.12.2025
Online
Places free
Implementation secured
Online
Places free
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.