Microsoft Visual Basic for Applications (VBA) Training

VBAMicrosoft Visual Basic for Applications (VBA) is a powerful development technology for rapidly customising rich-client desktop packaged applications and integrating them with existing data and systems.

VBA offers a sophisticated set of programming tools based on the Microsoft Visual Basic development system, the world’s most popular rapid application development system, which developers can use to harness the power of packaged applications.

VBA enables you to buy off-the-shelf software and customise it to meet their specific business processes, rather than build solutions from scratch. This helps them save time and money, reduce risks, leverage their programming skills, and deliver precisely what users need.

Which level course would you like?

1. Training with a highly experienced Microsoft VBA certified trainer.

2. A full colour A4 VBA manual for you to take home.

3. Free parking at our site.

4. Lunch and plenty of refreshments through out the day.

5. A comfortable, air conditioned training environment.

6. The exercises that you will work on (Where appropriate a USB stick is provided for you to take your training exercises away with you)

Reviews of Acuity Training From VBA Training Course Delegates

5 out of 5 “Absolutely brilliant. Really useful and learnt loads. Thanks so much for putting this course on for me. It’s going to save me so much time.” Balfour Beatty

5 out of 5 “Steven was excellent.  Made things very clear, a good trainer too.  Material and content very good, good pace.” Administrator, BOC

5 out of 5 “Particularly enjoyed course & Les was very approachable and helpful. Also interested in HTML, XML and  XSLT” Air Vehicle Consultant, QinetiQ

5 out of 5 “Very good, thank you” Partner, JK Investment

Course Approach

These courses are focused on ensuring that we make you a faster and more confident VBA user. Given how widely VBA is used to automate repetitive tasks in the Office Suite we believe that being a confident VBA developer is a key career skill for anyone developing for the Office environment.

Our courses are deliberately very hands-on. We believe that practical skills are developed through guided practice. This reinforces classroom learning and shows you how to apply what they are learning. Our exercises are carefully chosen to emphasise the key aspects of each lesson.

Uses Of VBA

Visual Basic for Applications is applicable to any program in the Office suite, although it is used most frequently with Excel and Access.  It allows everything from small, repetitive tasks to be automated through to full applications to be developed sitting on top of the Office suite of programs. Given how widely Microsoft Office is used VBA is used in a huge number of different applications.

Examples of the way that VBA can be used include creating user input forms to ensure that all data required is input, automating the production of charts and reports from raw data and manipulating data that is received in one format but which needs to be changed into another format.

Background & Overview

VBA is a simple programming language to pick up. It does not require a separate code editor as one is available within the Office suite. It is available in Access, Excel, Outlook, PowerPoint and Word and also partially available in AutoCAD and CorelDraw. It runs within a specific Office application and is not, in general, used to develop independent applications. VBA was not made available in Office for Mac 2008 however it is available in all other versions of Office for Mac.

the macro recorder function within Office programs means that large amounts of VBA can be very rapidly written in many circumstances. The macro recorder can be used to create large amounts of code. This is then manually amended, where required, to ensure the code works as required. This is far faster than writing code from scratch.

Similar Courses

Delegates interested in Excel training often are also interested in:

 Microsoft Access Training SPSS Training Courses


Further References 

Further information on Excel can be found at the following websites:

Wikipedia:    VBA Article

Microsoft:   VBA Page