Training Excel VBA basics
Training description
At this training you will learn about concepts such as procedure, method, variable or function, and you will gradually learn the principles for automating Excel activities. In the examples we will show how the conditions and cycles work, what objects are and how to use them. We will prepare user messages or dialogs. Participants will receive free training materials with exercises and a description of how to elaborate tasks.
Modul EXCEL9
- Recording macros (absolute vs. relative macro, keyboard shortcuts, go to – special)
- Object-oriented approach (Objects WorkSheet, WorkBook, Range, Collection)
- Variables, constants, data types and their definitions
- Properties and methods
- Conditions and cycles (If, Do while, For, For each, Select Case)
- Messages and dialogs (MsgBox, InputBox)
- Abbreviated writing and code checking
- Using ChatGPT for programming
Zanechat komentář