Präsenzreihe
Excel VBA Programmierung Aufbau - Microsoft Office Training
Do you want to start multiple functions with one button click? This VBA training is aimed at advanced Excel users who want to deepen their knowledge.
Diesen Kurs teilen
Beschreibung
Seminar content
Protecting modules, working with certificates
Passing on procedures with add-ins
Extended data types - arrays, compounds, enumeration variables
One-dimensional and multidimensional arrays
Using dynamic and static arrays
Validity ranges of variables, variable passing byVal and byRef
Using object variables, referencing objects
Range object, chart object, pivot table object
Deepening: events, for-each, user-defined functions
Programming in the area of folders/files
Create ASCII or CSV files
Access to integrated Excel dialogs and office dialogs
Deepening: Create own dialog forms
Create your own error messages
Accessing other Office applications
Translated with www.DeepL.com/Translator (free version)
Ziel
/
Anforderungen an die Teilnehmer
VBA programming Microsoft Office Excel basic seminar or comparable knowledge
Teilnehmer
Microsoft Office Excel user
