VBA Training Courses
If you need to learn VBA, you've come to the right page! Whether you want VBA classroom training courses, exercises, blog articles or an online tutorial, the links below will help.
VBA classroom training
We run the following VBA programming training courses:
Can't see the course you want? Have a look at our onsite Visual Basic for Applications training page, or see our other VBA training resources.
Not sure which course you want? See what you can learn on one of our VBA courses.
Which is the right VBA course for you?
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 yo'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!
You can get even more help on choosing the right VBA course for you here.
10 things our VBA courses include
Each of our scheduled courses includes:
- Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
- A computer for each delegate (obviously).
- A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
- Full colour courseware of oustanding quality (download a sample VBA courseware chapter to judge this claim for yourself) .
- Interesting exercises to reinforce what you've learnt (you can review some of the VBA exercises we use here).
- Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
- 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.
- A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
- A Sheaffer biro and notepad.
- 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).
Have a look at our full list of benefits, or read hundreds of testimonials to the quality of our training.
Scheduled VBA training dates
Here are the VBA courses we have scheduled for the next 3 months:
| Course | Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|---|
| Advanced VBA | Tue/Wed 17-18 July 2018 | 2 | Manchester | £750 | Book places |
| Excel VBA macros | Thu/Fri 26-27 July 2018 | 2 | Manchester | £695 | Book places |
| Excel VBA macros | Thu/Fri 02-03 August 2018 | 2 | London | £850 | Book places |
| Excel VBA macros | Thu/Fri 13-14 September 2018 | 2 | London | £850 | Book places |
| Course | Date(s) | Venue |
|---|---|---|
| Advanced VBA | 17/07 | Manchester |
| Excel VBA macros | 26/07 | Manchester |
| Excel VBA macros | 02/08 | London |
| Excel VBA macros | 13/09 | London |
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
Try our VBA exercises
To continue the spirit of transparency, we've published all of our Excel VBA exercises online:
VBA training venues
Our VBA courses run in the following locations:
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:
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 courseware manuals
To help you evaluate whether to entrust yourself to a Wise Owl VBA training course, we've provided some sample courseware chapters:
VBA books or publications
If you're trying to teach yourself VBA, you might find the following book useful:
Videos on VBA
Watch our series of videos showing you how to program in VBA, including creating user forms:
Test your VBA skills
Assess your knowledge of Visual Basic for Applications programming: