This page has 0 threads | Add post

Wise Owl's VBA Training Courses

Sam (one of our 7 Wise Owl trainers)

Preferred venue/format

Benefits of our VBA training

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.

Hidden

Friendly and professional training ... guaranteeed▼

How can any training company guarantee the quality of their courses? Here's how:

We limit our courses to no more than 6 people per class.
Unlike almost every other computer training company, we never subcontract or use freelancers - here's why this matters.

The best courseware in the industry? See for yourself▼

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:

Genuine integrity - and good manners▼

Our values are simple - we treat people as we would like to be treated ourselves. So:

We will - almost never - cancel courses. To see what "almost never" means see our no cancel guarantee.
There's nothing worse than being pestered, so we don't pester people. Ever.
It's dangerous to be sanctimionius, but we can see no possible benefit that tobacco and gambling companies bring to the world (and quite a lot of harm), so we choose not to work for them. Sorry.

You can see more on our corporate values here.

Innovative online training platform▼

We've put a lot of thought into making our online courses as useful and interactive as possbile:

Delegates use Remote Desktop to connect to our machines, so our trainers can see everyone's screens at all time.
We arrange (without charge) a half-hour pre-course check for each online delegate before courses, to ensure that they everyone will be able to join the course seamlessly when it begins.
As well as providing a PDF of the manual and exercises for each online course delegate we will (again without charge) also post this out to each person a few days before if required.

Choose a specific course, or stay on this page to see all of our VBA training.

Course:

Our current Visual Basic for Applications scheduled courses

Can't see the dates/course type that you want? Create your own onsite course (and tailor the content too!).

Course	Dates	Venue/type	Duration	Price	Times
We don't have any scheduled courses for this combination of criteria: please try different options.
Excel VBA macros	Mon/Tue 17-18 March 2025 17-18 Mar	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Advanced VBA	Wed/Thu 26-27 March 2025 26-27 Mar	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Excel VBA macros	Thu/Fri 10-11 April 2025 10-11 Apr	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Fast track Excel VBA	Tue/Thu 22-24 April 2025 22-24 Apr	Online	3 days	£1,350.00 + VAT	09:30-16:30	Book
Excel VBA macros	Mon/Tue 12-13 May 2025 12-13 May	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Advanced VBA	Mon/Tue 02-03 June 2025 02-03 Jun	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Excel VBA macros	Tue/Wed 10-11 June 2025 10-11 Jun	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Fast track Excel VBA	Mon/Wed 16-18 June 2025 16-18 Jun	Online	3 days	£1,350.00 + VAT	09:30-16:30	Book
Excel VBA macros	Thu/Fri 10-11 July 2025 10-11 Jul	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Advanced VBA	Mon/Tue 04-05 August 2025 04-05 Aug	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Excel VBA macros	Mon/Tue 11-12 August 2025 11-12 Aug	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Fast track Excel VBA	Wed/Fri 13-15 August 2025 13-15 Aug	Online	3 days	£1,350.00 + VAT	09:30-16:30	Book
Excel VBA macros	Tue/Wed 09-10 September 2025 09-10 Sep	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Advanced VBA	Wed/Thu 01-02 October 2025 01-02 Oct	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Excel VBA macros	Thu/Fri 09-10 October 2025 09-10 Oct	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Fast track Excel VBA	Tue/Thu 14-16 October 2025 14-16 Oct	Online	3 days	£1,350.00 + VAT	09:30-16:30	Book
Excel VBA macros	Mon/Tue 10-11 November 2025 10-11 Nov	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Advanced VBA	Mon/Tue 01-02 December 2025 01-02 Dec	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Excel VBA macros	Tue/Wed 09-10 December 2025 09-10 Dec	Online	2 days	£995.00 + VAT	09:30-16:30	Book
Fast track Excel VBA	Tue/Thu 09-11 December 2025 09-11 Dec	Online	3 days	£1,350.00 + VAT	09:30-16:30	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.

Our Visual Basic for Applications classroom training venues

What other people have said about our VBA training

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.

"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

"Our trainer made the course very enjoyable with his enthusiasm and humour. He made sure I felt like I could ask all and any questions I wanted, despite also having to pay extra attention to the other trainee."

Philip Howlett

Macquarie Energy Leasing

"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

"Very much enjoyed the casual nature of the course and the real life examples and activities used."

Mareks Liepa

Nexperia UK Ltd

"All good, informative, friendly and entertaining. Our trainer provided excellent service."

Marcin Gabryelski

Nexperia UK Ltd

"Having never used visual basic before everything on the course was new to me, but the trainer was clear, concise and approachable throughout. Everything on the course was relevant to my role. The trainer even took the time to help me create a sub routine for a real world example, which was much appreciated! I would recommend Wise Owl to anyone."

Lucy Kavanagh

National Nuclear Laboratory

About our VBA 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:

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.

FAQs (Frequently Asked Questions

Click on any heading below to learn more.

How can I contact you with any questions?▼

You can reach us in one of the following ways:

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!
Email	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!

Do you offer VBA consultancy too?▼

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: Get specific details about our Visual Basic for Applications consultancy, or more general information about how our consultancy works.

Is there an easy way for me to assess my VBA skills?▼

You can take the following tests to assess your Visual Basic for Applications skills on this site:

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).

Do you have any VBA videos?▼

We've got the following videos on our site to help you to learn VBA:

Category	Description	Videos
Excel VBA - Basics	This set of videos roughly follows the contents of our two-day introduction to VBA course.	25
VBA Tips	Tips and tricks for working with VBA macros.	3
VBA User Forms	You can draw custom dialog boxes in VBA called user forms, and manipulate their controls using VBA (as this series of tutorials will teach you).	22
Excel VBA - pivot tables	Videos on how to programmatically manipulate pivot tables, charts and PowerPivot within Excel.	9
Excel VBA - charts	Using VBA to create and manipulate charts, including how to conditionally format them.	6
VBA - advanced	Miscellaneous additional VBA topics which don't fit conveniently into any other category (including working with arrays, ByRef and ByVal arguments and much more).	15
VBA - working with files	Using FileSystemObjects to manipulate files and folders in VBA, and saving data as PDF files.	12
VBA - linking applications	Linking Excel, Word, PowerPoint, Outlook and other Microsoft Office applications programmatically.	14
VBA - working with Outlook	Using Outlook with VBA, including how to create emails and loop through folders in Outlook.	14
Built-in VBA functions	Videos on how to use some of the built-in VBA functions, and also videos on working with specific data types such as strings and dates.	9
VBA - working with data	Getting VBA to work with recordsets of data from Access or SQL Server, or any other data source for that matter.	58
VBA - scraping websites	Using VBA to scrape websites (that is, to download the HTML content and programmatically parse this to extract content).	28
VBA - working with shapes	Creating, editing, looping over and deleting shapes (including text boxes, regular polygons and call-outs) using VBA.	5
VBA - classes and structures	Object-oriented programming in VBA: creating and using classes and structures to encapsulate the logic of an object (including understanding properties, methods and collections).	6

Do you ever blog about VBA?▼

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

Blog topic
VBA blogs
Blogs on VBA within Excel

Do you have any other VBA learning resources?▼

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

This page has 0 threads

Add a new post