COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Excel VBA macros

Classroom Training

Excel VBA macros -

Classroom training course - online version also available

£695 + VAT for most venues (£850 + VAT for London)

2 days

Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).

Course details

  • Locations for Excel VBA macros coursesPossible locations:London, Manchester, Online
  • Next Excel VBA macros course locationNext classroom course:Tue 18 August 2020
  • Excel VBA macros course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Recording macros and buttons

  • Absolute and relative recording
  • Where macros can be stored
  • Assigning macros to buttons

Selecting cells

  • Selecting cells (absolute)
  • Selecting cells (relative)
  • Selecting to the end of a block
  • Selecting a range by its corners

The VB code editor

  • Using Project Explorer
  • Creating modules
  • Basic subroutines and comments

Messages and variables

  • Input boxes and message boxes
  • Declaring variables
  • Option Explicit
  • Scope of variables
  • Constants

Visual Basic explained

  • The Excel object model
  • Objects and collections
  • Methods and properties
  • Getting help in VBA

Loops and conditions

  • Simple IF conditions
  • Multiple IF and SELECT / CASE
  • Three main types of loop

Looping over collections

  • Object variables
  • Looping over collections

Event handling

  • Assigning macros to events
  • Cancelling events

Functions

  • Declaring functions
  • Passing arguments

Debugging and error handling

  • Setting breakpoints
  • Stepping through macros
  • ON ERROR statements

Forms

  • Drawing forms
  • Attaching macros to controls
  • Validating form input

Covered if time allows If time

Referencing other applications

  • Links to Word or Access
  • Working with files and folders

Delegates should be comfortable with using Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

Why Choose Us?

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).

"Great course, so helpful!"

Alexandra Black (Global Aerospace)

"The course was very interesting and interactive. I've attended previous courses (as have colleagues). Will attend further courses."

David Williamson (National Nuclear Laboratory)

"Brilliant course, well delivered. This is the 3rd Wise Owl course I have attended and I always leave with ideas on how I can use the course content within the business."

Paul Atterbury (Marley Ltd)

"Manuals are always brilliant."

Ersin Cimener (Tesco)

"The trainer was very patient and clear during training. The manual and exercise books and USB will be useful to remember what I've learned."

Kadija Saidi (Surrey County Council)

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

Scheduled Excel VBA macros training dates

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

Dates Days Venue Price Booking
Tue/Wed 18-19 August 2020 2 £850 Book places
Tue/Wed 15-16 September 2020 2 £695 Book places
Tue/Wed 13-14 October 2020 2 £850 Book places
Thu/Fri 05-06 November 2020 2 £695 Book places
Thu/Fri 19-20 November 2020 2 £850 Book places
Tue/Wed 08-09 December 2020 2 £695 Book places
Date(s) Venue
18/08
15/09
13/10
05/11
19/11
08/12

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

Advanced VBA

Very advanced

2 day course

Excel Advanced

Advanced

2 day course

Excel Business Modelling

Advanced

2 day course

Other Visual Basic for Applications training resources

VBA exercises

VBA exercises

Teletubbies, Wombles, Elmer the elephant - there are all sorts of exciting exercises on VBA programming published on this site!

View Excel VBA or Advanced VBA exercises

VBA videos

VBA videos

We've created a suite of videos explaining different aspects of VBA (although people learn best from other people, we've found).

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

VBA skills assessment

VBA skills assessment

You can test your VBA knowledge by seeing how it stacks up relative to that of others at this skills assessment site.

View How well do you know Excel VBA? skills assessment tests

VBA blogs

VBA blogs

There's a full-blown online tutorial included in the blogs we've published on Visual Basic for Applications.

View VBA macros blogs

This page has 0 threads Add post