£675 + VAT for most venues (£795 + 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 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.
Nathan Sexton (University of Kent)
Jonathan Pearce (Sellafield Ltd.)
Lorna Sherrin (CEH Lancaster)
Owen Mitchell (Catlin)
Andrew Petherbridge (Health Education East Midlands)
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:
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.
View VBA macros blogs