WiseOwl Training - Established 1992
Browse 534 attributed reviews, viewable separately for our classroom and online training
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.44/10, based on our 2,229 latest reviews
Classroom training - Advanced VBA

Classroom Training

Advanced VBA

Classroom training course - online version also available

£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 coursesPossible locations:London, Manchester, Online
  • Next Advanced VBA course locationNext classroom course:Mon 15 November 2021
  • Advanced VBA course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

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

Covered if time allows 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

Covered if time allows If time

Advanced programming ideas

  • Using functions in code
  • Recursive programming
  • Enumerations

Covered if time allows If time

Working with shapes

  • Adding shapes
  • Positioning shapes
  • Formatting shapes

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. 

Why Choose Us?

View full list of benefits

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Very informative. The course gave a great introduction to the basics, allowing for sound further application. Great trainer."

Jess Wibberley (Ministry of Housing, Communities and Local Government (MHCLG))

"The trainer's approach made me feel very comfortable and I gained confidence quickly in my abilities as I progressed through the course. Lots of practical exercises to reinforce what I thought I knew, and yet still lots of time to go out on tangents when necessary, Fantastic. Wish I could do it again! Very excited to apply what I've learned. I wanted a training provider that offered more of a personal touch really. Everyone learns differently and I didn't like the idea of attending a seminar style course. This was anything but that, very personal, focused and enjoyable. Thank you."

Puc Covelli (Integrate Media Limited)

"I thought the course was excellent. Will definitely use again."

Claire Mark (Sage Publishing)

"Our training group all had differing SSRS experience due to being self-taught, but the course was tailored to suit our specific needs which we really appreciated. The trainer asked for subjects we would like to focus on and this really helped us get the most out of the training. I enjoyed the course and I am looking forward to putting what I learnt into practice."

Charlotte Hall (Leeds Community Healthcare NHS Trust)

"We have used Wise Owl in the past and the fast track course was just what we needed to get everyone up to speed regardless of experience. Being the only company on the course allowed us to steer the content and questions towards our particularly business which was really useful. Overall very pleased with the training and excellent course manual provided."

Mark Webb (Sesame Bankhall Group)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Advanced VBA training dates

Here are the classroom Advanced VBA courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Tue 15-16 November 2021 2 Manchester £750 Book places
Date(s) Venue
15/11 Manchester

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, Excel VBA - pivot tables, Excel VBA - charts, VBA - working with Outlook, VBA - working with shapes or VBA - classes and structures 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