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
546 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 ...
We're experts in VBA, but also know how to train small classes (maximum 6 people) in a friendly way, whether in a classroom setting or online.
We currently run the following scheduled VBA courses:
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.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the next VBA courses we have scheduled:
Course | Dates | Venue |
---|---|---|
Advanced VBA | 05-06 Dec | Online |
Fast track Excel VBA | 09-11 Dec | Online |
Excel VBA macros | 10-11 Dec | Online |
Excel VBA macros | 09-10 Jan | Online |
Advanced VBA | 05-06 Feb | Online |
Excel VBA macros | 10-11 Feb | Online |
Fast track Excel VBA | 12-14 Feb | Online |
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 training at your offices (we'll even provide the computers and projector).
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 ...
There are many ways in which we can help you learn VBA!
To continue the spirit of transparency, we've published all of our Excel VBA exercises online.
We've blogged extensively on Visual Basic for Applications macros - mainly for Excel, but also for Access and other MS Office applications.
As well as (or instead of) attending our VBA course in the UK, you could instead follow our online training course.
Watch our series of videos showing you how to program in VBA, including creating user forms.
Have a look at our VBA full tutorials, as well as our shorter tips and tricks.
Our VBA courses run in the following locations.
You can sample or license the following courseware manuals.
Assess your knowledge of Visual Basic for Applications programming.
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.
If you're trying to teach yourself VBA, you might find the following book useful.
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 2024. All Rights Reserved.