Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

VBA Training Courses

We're experts in VBA, but also know how to train small classes (maximum 5 people) in a friendly way, whether in a classroom setting or online.

We currently run the following scheduled VBA courses:

Excel VBA Advanced VBA 3-day fast-track VBA
Not exactly the course contents you want? Why not consider organising your own tailored VBA course)?

More about our Visual Basic for Applications training

For the vast majority of people we'd recommend that you book onto our two-day Introduction to Excel VBA course - even if you already know some VBA.

Although this course is aimed at absolute beginners, we've often found that the people who get the most out of it have a bit of VBA experience.

The course will show you how to write structured VBA programs, including comments and indentation.  Programs like this, in fact:

Sub SelectFirstEmptyCell()

'go to the right worksheet

Worksheets("Owls").Select

'go to the top cell

Range("A1").Select

'go to the bottom cell, then one further

ActiveCell.End(xlDown).Select

ActiveCell.Offset(1, 0).Select

'write in an owl name

ActiveCell.Value = "Flappy Owl"

End Sub

If you're worried that this course would be too basic for you, ask yourself these questions:

  1. Do you know what Option Explicit means?

  2. Do you know when you would use the word SET to assign a variable value?

  3. Do you know what objects, collections, methods and properties are?

  4. Do you know how to use FOR EACH ... NEXT to loop over collections?

If the answer to all of these is yes, have a look at our advanced VBA course.  This will show you how to work with other applications (among many other things).  For example, the following code would delete any Excel files in the current folder:

Sub DeleteExcelWorkbooks()

'new container for working with files

Dim fso As New FileSystemObject

Dim fil As File

Dim fol As Folder

'get reference to a folder

Set fol = fso.GetFolder("c:\wise owl\")

'loop over files in current folder

For Each fil In fol.Files

If LCase(Right(fil.Name, 5)) = ".xlsx" Then

'delete all Excel workbooks

fil.Delete

End If

Next fil

End Sub

If you're interested, this creates a reference to the Microsoft Scripting Runtime object library.  If you want to understand how to do this (and what that sentence means), book on the course!

Finally (for people who are short on time but quick learners) we have a fast-track VBA course which combines the contents of our introductory and advanced VBA courses in an intensive three days.  You can get even more help on choosing the right VBA course for you here.

10 things our courses include

Each of our scheduled courses (whether classroom or online) includes:

  1. Small course sizes - we have a maximum of 6 people on each classroom or online course.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
  3. Full colour courseware and exercises of oustanding quality.
  4. A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
  5. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
  6. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  7. A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

  1. A computer for each delegate (obviously).
  2. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  3. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

Scheduled VBA training dates

Here are the VBA courses we have scheduled for the next 3 months:

Course Dates Days Venue Price Booking
Excel VBA macros Thu/Fri 25-26 January 2024 25-26 Jan 2 Online £825 Book places
Advanced VBA Mon/Tue 05-06 February 2024 05-06 Feb 2 Online £825 Book places
Excel VBA macros Wed/Thu 21-22 February 2024 21-22 Feb 2 Manchester £995 Book places
Fast track Excel VBA Wed/Fri 28th Feb/1st March 2024 28 Feb-01 Mar 3 Online £1,150 Book places

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite VBA training at your offices (we'll even provide the computers and projector).

About our VBA training

Wise Owl are VBA gurus!  We've been teaching businesses how to automate routine tasks using Excel macros for many years, and many of our internal systems are written in VBA too.  Here are a few examples:

Application Notes
This website We use a suite of VBA modules and forms within SharePoint Designer to automate writing HTML for many pages of our website.
Our manuals We create our manuals using Microsoft Word, with a host of routines written in VBA to automate content creation.
Scheduling courses Our course scheduler in Excel uses VBA macros for common tasks like creating a calendar and scheduling new dates.
Website management Our website CMS system is written in Access (with SQL Server as a back-end), using VBA throughout.

Oh, and did we mention that programming in VBA is really satisfying?  Well, when it works it is ...

Other Visual Basic for Applications training resources

There are many ways in which we can help you learn VBA!

Try our VBA exercises

To continue the spirit of transparency, we've published all of our Excel VBA exercises online.

Excel VBA exercises Advanced VBA exercises

Blogs on VBA

We've blogged extensively on Visual Basic for Applications macros - mainly for Excel, but also for Access and other MS Office applications.

VBA blogs Blogs on VBA within Excel

Self-paced VBA online training

As well as (or instead of) attending our VBA course in the UK, you could instead follow our online training course.

Online course in VBA

Videos on VBA

Watch our series of videos showing you how to program in VBA, including creating user forms.

VBA for Excel User forms Pivot tables and charts Charts Advanced VBA Files/folders References Outlook Built-in functions ADO.NET Scraping websites Working with shapes Classes and structures

VBA training venues

Our VBA courses run in the following locations.

VBA training in Manchester VBA macro training in London Onsite VBA training (UK)

VBA courseware manuals

Introducton to Excel VBA Advanced VBA macros Fast-track VBA

Test your VBA skills

Assess your knowledge of Visual Basic for Applications programming.

How well do you know Excel VBA?

VBA consultancy

No one knows VBA like Wise Owl, and no other company has the same ability to write complex systems AND then explain how they work.

VBA consultancy

VBA books or publications

If you're trying to teach yourself VBA, you might find the following book useful.

Introduction to Excel VBA Introduction to VBA in Excel Excel VBA book Excel VBA introduction
This page has 0 threads Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...