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

Visual Basic for Applications is the programming component of Microsoft Office and this course introduces the basics aspects of the language itself. As such there is no mention made of any particular member of the Office family and thus this course is the common starting place for anyone who is ready to move onto this aspect of Office work.

• Introduction to VBA
• Code Structure
• Getting Help
• Variables and Constants
• Data Types
• Conditional Statements
• Debugging
• Functions and the use of Modular Code
• Data Scope and Survival
• Error Handling
• Repeating Instructions