Classroom Training
Classroom training course - online version also available
£950 + VAT for most venues (£1,095 + 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.
The contents of this course are as follows:
If time
If time
If time
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:
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.
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Paul Maxwell (Innogy Business Services UK Ltd)
Graham Davies (Lex)
Puc Covelli (Integrate Media Limited)
Lianne Pierre John (Barbican Insurance / Arch Capital Gp Ltd)
Joyce Fajemirokun (Girls' Day School Trust)
There are lots more where these came from (or just refresh this page to change the quotes shown).
View Excel VBA or Advanced VBA exercises
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, Excel VBA - pivot tables, Excel VBA - charts, VBA - working with Outlook, VBA - working with shapes or VBA - classes and structures videos
View How well do you know Excel VBA? skills assessment tests
View VBA macros blogs