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:Mon 01 October 2018
Time:09.30-16.30
Course Contents
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
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 532 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
David Pearson (BAE Systems)
Andrew Glinwood (Downey & Co Ltd)
David Johnston (D M J Business Consulting)
Ersin Cimener (Tesco)
Alison Phiri (NHS Leeds CCG)
There are lots more where these came from (or just refresh this page to change the quotes shown).
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.
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 |
|---|---|---|---|---|
| Mon/Tue 01-02 October 2018 | 2 | Manchester | £695 | Book places |
| Thu/Fri 18-19 October 2018 | 2 | London | £850 | Book places |
| Thu/Fri 08-09 November 2018 | 2 | London | £850 | Book places |
| Tue/Wed 20-21 November 2018 | 2 | Manchester | £695 | Book places |
| Thu/Fri 13-14 December 2018 | 2 | London | £850 | Book places |
| Thu/Fri 10-11 January 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 31st Jan/1st February 2019 | 2 | London | £850 | Book places |
| Tue/Wed 19-20 February 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 12-13 March 2019 | 2 | London | £850 | Book places |
| Thu/Fri 28-29 March 2019 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 01/10 | Manchester |
| 18/10 | London |
| 08/11 | London |
| 20/11 | Manchester |
| 13/12 | London |
| 10/01 | Manchester |
| 31/01 | London |
| 19/02 | Manchester |
| 12/03 | London |
| 28/03 | 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 or Excel VBA - pivot tables/charts 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