With the help of the VBA programming language available in Excel, recurring work steps can be made easier and complex tasks can be automated.
What does VBA mean?
Linking VBA procedure with menu bar
Working with the VBA development environment
The language elements of VBA
Variables, constants and their data types
Controlling program flow with control structures
Object-oriented programming with VBA
What are objects ?
Object hierarchies (object models)
Properties and methods of objects
Shared VBA elements
VBA elements for all Office applications
Programming the application window
Programming the document window
Programming the file system
Input dialogs and message windows
Good knowledge of Microsoft Office Excel
Microsoft Office Excel user