VBA Training
Advanced VBA Training Course
£750 + VAT for most venues (£895 + VAT for London)
2 days
If you already know how to create subroutines in VBA, are happy declaring variables and can write loops and conditions without a qualm, this is the course for you! Assuming a good working knowledge of Visual Basic for Applications, the advanced course shows you how to loop over collections, reference other applications, work with files in all of their manifestations, create your own classes (!) and much more. The course uses examples drawn from Excel, Access, Word and Outlook.
Course details
Locations:London, Manchester
Next course:Tue 05 March 2019
Time:09.30-16.30
Course Contents
Revision of VBA
Objects and collections- Methods and properties
- Using object variables
- Looping over collections
Links to other applications
- Referencing other applications
- Instantiating objects
- Writing inter-application code
FileSystemObjects
- Referencing FileSystemObjects
- Working with files and folders
FileDialogs
- Using FileDialogs
- Allowing multiple selection
Working with text files
- Avoiding using INPUT/OUTPUT
- Reading and writing text files
Class modules
- What is a class?
- Designing classes
- Creating properties and methods
- Consuming classes
If time
Advanced class modules topics
- Untyped collections
- Creating typed collections
- Creating event sinks
Linking to data
- ADO or Access Database Engine
- Referencing the right library
- Opening and using recordsets
Arrays
- Creating and populating arrays
- Dynamic arrays
- The PRESERVE keyword
Passing arguments
- ByRef and ByVal
- Using optional arguments
- Using ParamArray
If time
Advanced programming ideas
- Using functions in code
- Recursive programming
- Enumerations
If time
Working with shapes
- Adding shapes
- Positioning shapes
- Formatting shapes
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 484 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Mark Anderton (NHS Leeds CCG)
Joseph A. Borg (Cummins Generator Technologies Ltd)
Marc Vautheny (Business Growth Hub)
Stuart Allan (Lloyds Banking Group)
Matthew Clarke (Xpedite GoC)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Delegates should have good knowledge of either Access Visual Basic, Excel Visual Basic or Word Visual Basic. To attend this course, you should already know the answers to these questions:
- How to use input and message boxes.
- How to write IF conditions and loops.
- How to create and use variables (including the use of OPTION EXPLICIT).
- How to select cells (including using OFFSET and END) in Excel.
If you haven't attended our two-day Excel VBA introduction course or been using VBA for at least 6 months, you're likely to struggle on this course.
Scheduled Advanced VBA training dates
Here are the Advanced VBA courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Tue/Wed 05-06 March 2019 | 2 | Manchester | £750 | Book places |
| Thu/Fri 21-22 March 2019 | 2 | London | £895 | Book places |
| Thu/Fri 09-10 May 2019 | 2 | Manchester | £750 | Book places |
| Tue/Wed 18-19 June 2019 | 2 | London | £895 | Book places |
| Thu/Fri 04-05 July 2019 | 2 | Manchester | £750 | Book places |
| Thu/Fri 05-06 September 2019 | 2 | Manchester | £750 | Book places |
| Thu/Fri 26-27 September 2019 | 2 | London | £895 | Book places |
| Tue/Wed 12-13 November 2019 | 2 | Manchester | £750 | Book places |
| Tue/Wed 10-11 December 2019 | 2 | London | £895 | Book places |
| Date(s) | Venue |
|---|---|
| 05/03 | Manchester |
| 21/03 | London |
| 09/05 | Manchester |
| 18/06 | London |
| 04/07 | Manchester |
| 05/09 | Manchester |
| 26/09 | London |
| 12/11 | Manchester |
| 10/12 | London |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite VBA training at your offices (we'll even provide and set up the computers).
Related Courses
Other Visual Basic for Applications training resources
VBA exercises
If you're considering booking and advanced VBA course, having a look at our exercises should help you to decide if we're the right training provider for you.
View Excel VBA or Advanced VBA exercises
VBA videos
Classroom training is the best way to learn programming, but just in case you disagree we've published VBA videos too.
View Excel VBA - Basics, VBA User Forms, VBA - advanced, VBA - working with files, VBA linking applications, Built-in VBA functions, VBA - working with data, VBA - scraping websites or Excel VBA - pivot tables/charts videos
VBA skills assessment
Think you know VBA? Take one of our skills assessment tests to see how you perform relative to your peers.
View How well do you know Excel VBA? skills assessment tests
VBA blogs
There are all sorts of blogs on the Wise Owl website on Visual Basic for Applications, including a full tutorial.
View VBA macros blogs