557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
We've split our introductory VBA training courses into a two-day Excel macros course and a two-day advanced VBA course (the latter also applies to Word, PowerPoint and other MS Office applications). We also offer a three-day fast-track VBA course.
This page gives an idea of what you'll learn on our VBA courses, but you can see far more at our main VBA training courses page.
Our two-day introduction to VBA in Excel course will show you how to create basic macros, including selecting cells and declaring variables. Here's an example:
'the name of each superhero
Dim HeroName As String
'the rating assigned to them
Dim HeroRating As Long
'go to the votes sheet and get the value of the superhero, and their rating
HeroName = Range("C4").Value
HeroRating = Range("C6").Value
'go to top of results
'go to first blank cell
'write variable values into this blank row
ActiveCell.Value = HeroName
ActiveCell.Offset(0, 1).Value = HeroRating
'copy formats from cell above (included here just to make macro complete)
Range(ActiveCell.Offset(-1, 0), ActiveCell.Offset(-1, 1)).Copy
Application.CutCopyMode = False
However, by day two you'll be writing some fairly ambitious macros, including looping over collections:
'a reference to each workbook in turn
Dim wb As Workbook
'for each of the open workbooks ...
For Each wb In Workbooks
'if it isn't this one containing the code (note that you can't directly compare two workbooks: instead, you must see if they have the same name)
If wb.Name <> ThisWorkbook.Name Then
'it's not the same - close it down, giving user a chance to save changes (this is the default)
'now go on automatically to the next workbook
Our two-day advanced VBA course is aimed at people who already know Visual Basic for applications, and want to learn about referencing other applications, using file dialog boxes, creating classes, passing arguments by reference or value, recursive programming and the like. To give you a taste, here's the sort of macro you'll learn from the advanced VBA course:
'try consuming your class!
Dim Guess As New clsLetterGuess
'keep guessing until letter guessed or too many goes
'display what was guessed
If Len(Guess.LetterGuessed) = 0 Then
MsgBox "No letter guessed"
MsgBox "You guessed " & Guess.LetterGuessed
'now get rid of the object (the garbage collector will
'do this anyway, so this line is not strictly
Set Guess = Nothing
If you don't think this looks that complicated, bear in mind that clsLetterGuess is an object which we've created!
This fast-track VBA course combines:
All of the topics from the two-day Introduction to Excel VBA course; and
Most of the topics from the two-day Advanced VBA course (the big omission is class modules, which notwithstanding the above we don't actually think are that useful in VBA).
The course is aimed at people who have a very good aptitude for VBA.
If your ambitions lie beyond MS Office, you might like to consider our other programming courses:
See our VBA page for more details on all things to do with Visual Basic for Applications training.
25 Aytoun Street