VBA Essential Skills
This course is designed for regular users of at least one of the core applications of Microsoft Office who wish to develop basic programming skills.
Our aim is to provide you with the necessary skills for good programming techniques that allow for flexibility in VBA programming.
We will introduce you to the fundamental requirements of VBA in terms of structure as well as the statements and methods that form the foundation of most code. Please note that there is nothing in this course that is specific to any one application. This course is intended to introduce VBA itself.
It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.
If you have files popping up with the message “Security Warning: Macros have been disabled. Enable Content.”, chances are you have a macro(s) in the background of the file you are using with VBA. This course gets you familiar with the basics of coding and the VBA Editor tools available to help get a better understanding what is happening in the background of your file(s).
We recommend that students have:
- A more than basic familiarity with at least one Microsoft Office application
- Introduction to VBA
- Code Structure
- Getting Help
- Variables and Constants
- Data Types
- Conditional Statements
- Functions and the use of Modular Code
- Data Scope and Survival
- Error Handling
- Repeating Instructions