Microsoft Office training -  Advanced VBA

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 for Advanced VBA coursesLocations:Manchester, London
  • Next Advanced VBA course locationNext course:Tue 09 October 2018
  • Advanced VBA course timesTime:09.30-16.30

Course Contents

Revision of VBA

  • Training topicObjects and collections
  • Training topicMethods and properties
  • Training topicUsing object variables
  • Training topicLooping over collections

Links to other applications

  • Training topicReferencing other applications
  • Training topicInstantiating objects
  • Training topicWriting inter-application code

FileSystemObjects

  • Training topicReferencing FileSystemObjects
  • Training topicWorking with files and folders

FileDialogs

  • Training topicUsing FileDialogs
  • Training topicAllowing multiple selection

Working with text files

  • Training topicAvoiding using INPUT/OUTPUT
  • Training topicReading and writing text files

Class modules

  • Training topicWhat is a class?
  • Training topicDesigning classes
  • Training topicCreating properties and methods
  • Training topicConsuming classes

Covered if time allows If time

Advanced class modules topics

  • Training topicUntyped collections
  • Training topicCreating typed collections
  • Training topicCreating event sinks

Linking to data

  • Training topicADO or Access Database Engine
  • Training topicReferencing the right library
  • Training topicOpening and using recordsets

Arrays

  • Training topicCreating and populating arrays
  • Training topicDynamic arrays
  • Training topicThe PRESERVE keyword

Passing arguments

  • Training topicByRef and ByVal
  • Training topicUsing optional arguments
  • Training topicUsing ParamArray

Covered if time allows If time

Advanced programming ideas

  • Training topicUsing functions in code
  • Training topicRecursive programming
  • Training topicEnumerations

Covered if time allows If time

Working with shapes

  • Training topicAdding shapes
  • Training topicPositioning shapes
  • Training topicFormatting shapes

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"I would like to say the training was absolutely fantastic, the trainer was brilliant and was able to answer any questions regardless of the context or complexity. The session was intense but well-paced and there was a great deal of flexibility so that it could be tailored to the three of us on the course! I had high expectations but was still surprised at the number of topics I learned including some interesting ad-hoc topics which were fascinating. I am going to beg my managers for as much budget as possible so that I can come back for more courses in the near future!! Thank You very much! "

Adam Yates (Bako North Western Ltd)

"Manuals are always brilliant."

Ersin Cimener (Tesco)

"Exceptional training, very well thought through and examples made things very understandable. The trainer was great in terms of expanding into different topics that were of particular interest and use to us. Your course content (compared to others) seemed to offer the best value in terms of learning a lot."

Robert Kingston (Xpedite GoC)

"Brilliant course and charismatic instructor gave me a perfect introduction and support through the content at a challenging pace, would recommend to anyone (and was recommended to me by others.) The course was brilliant and left me feeling far more confident in VBA and I will most likely be taking part in the Advanced VBA course in the near future. I would give any helpful negative feedback I had ....but luckily there were no bad points! "

Robert London (Prudential plc)

"Perfect, real-world applicable, friendly, well paced ... perfect. Course was recommended."

Marc Vautheny (Business Growth Hub)

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:

  1. How to use input and message boxes.
  2. How to write IF conditions and loops.
  3. How to create and use variables (including the use of OPTION EXPLICIT).
  4. 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 09-10 October 2018 2 £750 Book places
Thu/Fri 08-09 November 2018 2 £895 Book places
Thu/Fri 22-23 November 2018 2 £750 Book places
Tue/Wed 15-16 January 2019 2 £750 Book places
Tue/Wed 29-30 January 2019 2 £895 Book places
Tue/Wed 05-06 March 2019 2 £750 Book places
Tue/Wed 19-20 March 2019 2 £895 Book places
Date(s) Venue
09/10
08/11
22/11
15/01
29/01
05/03
19/03

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

Excel VBA macros

Introduction

2 day course

Access VBA macros

Introduction

2 day course

Introduction to VB.NET

Introduction

2 day course

Other Visual Basic for Applications training resources

VBA exercises

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

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

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

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

This page has 0 threads Add post