£750 + VAT for most venues (£895 + VAT for London)
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 content of this course are as follows:
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.
Robert Kingston (Xpedite GoC)
Matthew Clarke (Xpedite GoC)
Darren Campbell (Servochem (PTY) Ltd)
Geoff Doyle (Humankind Charity)
Stuart Allan (Lloyds Banking Group)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Here are the Advanced VBA courses we have scheduled for the next 3 months:
|Thu/Fri 26-27 September 2019||2||London||£895||Book places|
|Tue/Wed 12-13 November 2019||2||Manchester||£750||Book places|
|Tue/Wed 26-27 November 2019||2||London||£895||Book places|
|Tue/Wed 04-05 February 2020||2||Manchester||£750||Book places|
|Thu/Fri 27-28 February 2020||2||London||£895||Book places|
|Tue/Wed 31st Mar/1st April 2020||2||Manchester||£750||Book places|
|Tue/Wed 12-13 May 2020||2||London||£895||Book places|
|Tue/Wed 19-20 May 2020||2||Manchester||£750||Book places|
|Thu/Fri 16-17 July 2020||2||Manchester||£750||Book places|
|Tue/Wed 04-05 August 2020||2||London||£895||Book places|
|Tue/Wed 08-09 September 2020||2||Manchester||£750||Book places|
|Tue/Wed 06-07 October 2020||2||London||£895||Book places|
|Tue/Wed 27-28 October 2020||2||Manchester||£750||Book places|
|Tue/Wed 01-02 December 2020||2||London||£895||Book places|
|Tue/Wed 15-16 December 2020||2||Manchester||£750||Book places|
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).
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 or VBA - working with Outlook videos
View How well do you know Excel VBA? skills assessment tests
View VBA macros blogs