Courses

VBA Essential Skills

= Scheduled class    = Guaranteed to run    = Fully booked

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

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.

Prerequisites

We recommend that students have:

• A more than basic familiarity with at least one Microsoft Office application

At Course Completion

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.

Course Outline

• 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

 Print this page