Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
528 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Not sure if we deserve all the reviews you can see on this site? Here are some of the things we do (very) differently to earn them.
How can any training company guarantee the quality of their courses? Here's how:
Our course manuals and exercises are by some way the best in the computer training industry. Fortunately you don't have to take our word for this - you can see for yourself:
Our values are simple - we treat people as we would like to be treated ourselves. So:
You can see more on our corporate values here.
We've put a lot of thought into making our online courses as useful and interactive as possbile:
Choose a specific course, or stay on this page to see all of our VBA training.
Course:
Can't see the dates/course type that you want? Create your own onsite course (and tailor the content too!).
Course |
Dates |
Venue/type |
||||
---|---|---|---|---|---|---|
We don't have any scheduled courses for this combination of criteria: please try different options. | ||||||
Excel VBA macros | 17-18 Mar | Online | Book | |||
Advanced VBA | 26-27 Mar | Online | Book | |||
Excel VBA macros | 10-11 Apr | Online | Book | |||
Fast track Excel VBA | 22-24 Apr | Online | Book | |||
Excel VBA macros | 12-13 May | Online | Book | |||
Advanced VBA | 02-03 Jun | Online | Book | |||
Excel VBA macros | 10-11 Jun | Online | Book | |||
Fast track Excel VBA | 16-18 Jun | Online | Book | |||
Excel VBA macros | 10-11 Jul | Online | Book | |||
Advanced VBA | 04-05 Aug | Online | Book | |||
Excel VBA macros | 11-12 Aug | Online | Book | |||
Fast track Excel VBA | 13-15 Aug | Online | Book | |||
Excel VBA macros | 09-10 Sep | Online | Book | |||
Advanced VBA | 01-02 Oct | Online | Book | |||
Excel VBA macros | 09-10 Oct | Online | Book | |||
Fast track Excel VBA | 14-16 Oct | Online | Book | |||
Excel VBA macros | 10-11 Nov | Online | Book | |||
Advanced VBA | 01-02 Dec | Online | Book | |||
Excel VBA macros | 09-10 Dec | Online | Book | |||
Fast track Excel VBA | 09-11 Dec | Online | Book |
If you can't see the course you want listed above, don't despair! If you can muster 3 or 4 people together, it may well be worth organising an onsite course at your office (we'll provide and set up the computers), or else an online course tailored to your needs.
Here are some comments we've received about our VBA + training. You can see all of our 528 reviews here. We would like to sincerely thank the clients whose names are shown below for kindly agreeing to let us share their feedback.
"All good, informative, friendly and entertaining. Our trainer provided excellent service."
Marcin Gabryelski
Nexperia UK Ltd
"All good from my point of view, very happy with the training provided again. Have used Wise Owl for a number of courses now, always engaging trainers with good content so was happy to use again."
John Ensor
Montanaro Asset Management Ltd
"Thoroughly enjoyed the two days that we spent with the instructor! He was incredibly enthusiastic and seemed to thrive from the enthusiasm that we showed. His wealth of knowledge on the subject of VBA, the ease to which he could write it, and finally how he was able to deliver, made for a very impressive display! Would highly recommend."
Nathan Simmonds
ReAssure UK Services Limited
"A great trainer, his knowledge was amazing and he was really keen to help and make it relevant to us which was great! We were undecided between this and the three day intensive course but really happy we started on this course and can go away and do our own work on macros before moving on to the advance course!"
Grace Aspin-Radford
CFC Underwriting
"Really loved the course and we learnt so much!! Very easy to follow."
Sarah Underwood
CFC Underwriting
"Great course as always! Delivered well by our trainer, keeping at our pace and adapting to meet our requirements & questions."
Aron Bourne
Ultimate Products Global Sourcing (UPGS)
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:
Do you know what Option Explicit means?
Do you know when you would use the word SET to assign a variable value?
Do you know what objects, collections, methods and properties are?
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.
Click on any heading below to learn more.
Contact method | Details |
---|---|
Phone | Call us on (0161) 883 3606 and (within normal UK office hours) a friendly and helpful human will answer the phone! |
Send an email to our inbox and we'll aim to answer it within a couple of working hours. | |
Web | Fill in an enquiry form letting us know what you want to achieve, and we'll do our best to help! |
Skills you want to test |
---|
Excel VBA |
Each tests consists of 20 questions. The tests are free and anonymous, and at the end you'll see a full analysis of your results (as well as a comparison of how well you did relative to everyone else who has previously taken the test).
We've got the following videos on our site to help you to learn VBA:
Category | Videos |
---|---|
25 |
|
3 |
|
22 |
|
9 |
|
6 |
|
15 |
|
12 |
|
14 |
|
14 |
|
9 |
|
58 |
|
28 |
|
5 |
|
6 |
Blog topic |
---|
VBA blogs |
Blogs on VBA within Excel |
In addition to our classroom and online VBA training courses, we also have the following learning resources:
Resource | Notes |
---|---|
Online tutorials | Learn VBA from our free online tutorials |
Tips and tricks | Useful tips and tricks to make VBA easier |
Publications | We've written the ultimate teach yourself VBA book |
Self-paced learning | We've published a full self-paced VBA tutorial |
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.