Classroom Training
Excel VBA programming - intensive three-day course
Available as classroom training course only
3 days
If you're learninng to write VBA macros to automate what you do within Excel, for the majority of people our two-day Introduction to Excel VBA course will be perfect (it shows all the main syntax of VBA that you need to get going). However for those who want a little bit more, this intensive three-day course covers all of the introductory course together with selected topics from the advanced one (the only big thing not covered is class modules, which we think are barely worth learning for VBA). For more information on how are fast track courses work - and why they are only available as tailored courses - see these notes.
Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).
Course Contents
This fast-track course combines topics from the following other Wise Owl courses:
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
You only need a basic knowledge of Excel for this course. You'll find it easier if you have some programming experience, although this isn't essential. What you must have is a good aptitude for computers (otherwise this will be a l-o-n-g three days ...).
Why Choose Us?
- No more than 6 people per class
- Proper restaurant lunch included
- 533 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Annabel Devall (Cambridgeshire Constabulary)
Emma Pendlebury (Guardian Industries UK Ltd)
Chas Mills (Guardian Industries UK Ltd)
Thomas Felton (PricewaterhouseCoopers Services Ltd.)
Haidar Javed (Argos Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Visual Basic for Applications training resources
VBA exercises
We've published our (many) VBA exercises online, for you to review.
View Excel VBA or Advanced VBA exercises
VBA videos
We have tons of VBA online videos, to give you a headstart in learning how to program within Excel.
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
If you think you know VBA, put your knowledge to the test with our skills assessment tests.
View How well do you know Excel VBA? skills assessment tests
