Online
Webinar
Excel: Programming with VBA
Inhalte
- The Development Environment
- Components of the Development Environment
- Project Explorer
- Properties Window
- Module Window
- Working in the Module Window
- Basics of VBA Programming
- Applications of macros and VBA
- Macro recording
- A simple program
- Structure of procedures
- Comments and line wrapping
- VBA syntax
- Input and message boxes
- Use of macros in Excel
- Triggering macros
- Form design
- Control elements
- Basic language elements
- Objects?
- Properties, methods and events
- Objects on forms
- Naming conventions
- Working with the object catalogue
- Linking events and procedures
- Functions and variables
- Predefined functions
- Declaring variables
- Data types
- Declaration of constants
- Principles of event-oriented programming
- Overview of events
- Arguments in event procedures
- Event procedures in practical use
- Controlling the programme flow
- Programme flow charts
- Instructions sequences
- Two-way and multi-level selection
- Case selection
- Loops
- For loop
- While loop
- Until loop
- Do loop
- Further control structures (Exit, GoTo, Recursion)
- Extended language elements
- Object variables
- Listings
- Named arguments
- Troubleshooting and Error Handling
- Basics of error handling
- Testing procedures with step in
- Checking and monitoring variables
- Catching and handling run-time errors
- Objects in Excel
- Properties and methods of Excel objects
- With statements
- The object catalogue
- The Excel object model
- References to libraries
- Working with Excel data
- Searching directories
- Saving Excel files
- Checking if files are open
- Accessing sheets and cells
- Checking whether a sheet exists in a folder
- Transfer values to other sheets
- Working with columns and rows
- The Development Environment
- Components of the Development Environment
- Project Explorer
- Properties Window
- Module Window
- Working in the Module Window
- Basics of VBA Programming
- Applications of macros ...
Termine und Orte
| Datum | Dauer | Preis | ||
|---|---|---|---|---|
| Webinar | ||||
| 27.07.2026 - 29.07.2026 21 h | 21 h | Details | Details Jetzt buchen | |
| 16.11.2026 - 18.11.2026 21 h | 21 h | Details | Details Jetzt buchen | |
| 10.02.2027 - 12.02.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 19.04.2027 - 21.04.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 21.06.2027 - 23.06.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 23.08.2027 - 25.08.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 08.11.2027 - 10.11.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| Datum | Dauer | Preis | ||
|---|---|---|---|---|
| Webinar | ||||
| 27.07.2026 - 29.07.2026 21 h | 21 h | Details | Details Jetzt buchen | |
| 16.11.2026 - 18.11.2026 21 h | 21 h | Details | Details Jetzt buchen | |
| 10.02.2027 - 12.02.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 19.04.2027 - 21.04.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 21.06.2027 - 23.06.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 23.08.2027 - 25.08.2027 21 h | 21 h | Details | Details Jetzt buchen | |
| 08.11.2027 - 10.11.2027 21 h | 21 h | Details | Details Jetzt buchen | |