Microsoft Visual Basics for Applications (VBA) Word, Excel, Access

Greater output through automation in Excel

Who is it for?

Intermediate to Advanced users of Excel who are looking to build automated intelligent interfaces with interactive features to manage and present information.

What will I learn?
  • Develop custom solutions, automate tasks and increase performance
  • Editing the Excel ribbon to give access to new user defined functionality
  • Ensuring your code is secure, protecting the end user and troubleshooting errors

Course Details

  • Location: Portsmouth
  • Duration: 2 Days
  • Member: £625
  • Non-Member: £736

All fees subject to VAT

Book this course »
Next steps



Course Overview
  • Programming basics, structures and statements
  • The naming and types of variables
  • Using parameters with lifetimes and scope
  • Recording VBA and using Macros 
  • Basic form design, form handling and events
  • Error handling, trapping errors and debugging techniques
  • Development of modular code and test plans

Course Dates

This course is offered on demand and dates are available on application.

Company Sponsored Option

This course is also available as a company sponsored option which is for your delegates only, this is a flexible solution and can be tailored to reflect your business needs, delivered on a date, time and place to suit you - please contact us.


Group Discounts

Take advantage of these discounts when booking this course;

5% off for 2-3 people
8% off for 4-5 people
12% off for 6 or more people

« All Databases, Reporting and Programming courses


Our Courses and Services