VBA Training
Automating Excel with Macros Training Course
£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:London, Manchester
Next course:Thu 24 October 2019
Time:09.30-16.30
Course Contents
The content 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
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?
No more than 6 people per class- Proper restaurant lunch included
- 513 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Maddy Gorka (Department for Education)
Peter Cranmer (GM Business Support Ltd)
Emma Jellicoe (Groupe Bel UK Ltd)
Ersin Cimener (Tesco)
Eliza Hartley (Royal Bank of Scotland)
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 Excel VBA macros courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Thu/Fri 24-25 October 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 07-08 November 2019 | 2 | London | £850 | Book places |
| Tue/Wed 19-20 November 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 17-18 December 2019 | 2 | London | £850 | Book places |
| Tue/Wed 14-15 January 2020 | 2 | Manchester | £695 | Book places |
| Thu/Fri 06-07 February 2020 | 2 | London | £850 | Book places |
| Thu/Fri 05-06 March 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 24-25 March 2020 | 2 | London | £850 | Book places |
| Thu/Fri 30th Apr/1st May 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 05-06 May 2020 | 2 | London | £850 | Book places |
| Thu/Fri 04-05 June 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 07-08 July 2020 | 2 | London | £850 | Book places |
| Tue/Wed 14-15 July 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 18-19 August 2020 | 2 | London | £850 | Book places |
| Tue/Wed 15-16 September 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 13-14 October 2020 | 2 | London | £850 | Book places |
| Thu/Fri 05-06 November 2020 | 2 | Manchester | £695 | Book places |
| Thu/Fri 19-20 November 2020 | 2 | London | £850 | Book places |
| Tue/Wed 08-09 December 2020 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 24/10 | Manchester |
| 07/11 | London |
| 19/11 | Manchester |
| 17/12 | London |
| 14/01 | Manchester |
| 06/02 | London |
| 05/03 | Manchester |
| 24/03 | London |
| 30/04 | Manchester |
| 05/05 | London |
| 04/06 | Manchester |
| 07/07 | London |
| 14/07 | Manchester |
| 18/08 | London |
| 15/09 | Manchester |
| 13/10 | London |
| 05/11 | Manchester |
| 19/11 | London |
| 08/12 | 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
Other Visual Basic for Applications training resources
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
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
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
There's a full-blown online tutorial included in the blogs we've published on Visual Basic for Applications.
View VBA macros blogs