Excel VBA Intermediate

Course summary
1 day
225 - 240 GBP excl. VAT
Open / Scheduled
Next available date: 06/03/2020 09:30 - London
Course Dates
06/03/2020 09:30  (English)
225 GBP
05/06/2020 09:30  (English)
240 GBP
04/09/2020 09:30  (English)
240 GBP
04/12/2020 09:30  (English)
240 GBP
05/03/2021 09:30  (English)
240 GBP
STL courses

Excel VBA Intermediate

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... By the end of the course the delegate will be fully competent in the fundamentals of VBA, including working with functions, understanding objects, using expressions, variables and intrinsic functions.; This includes mastering forms and controls, and building user defined functions.; There will also be discussion of techniques for improving and optimizing code.

Suitability - Who should attend?

This course is suitable for advanced users of Microsoft Excel looking to further increase their knowledge of VBA.

Training Course Content

Storing information with variables

How and why you should declare variables
Determining which data type to use
Public v Private scope
Using variables to trap errors
Using the Locals window to observe variables

Creating functions

Writing your own User Defined Functions (UDFs)
Working with multiple arguments
Using your function in Excel

Message Boxes and Input Boxes

Displaying a message
Adding a yes / no user choice
Getting feedback from the end user

Handling Errors

Defining VBA's Error Trapping Options
Capturing Errors with the On Error Statement
Determining the Err Object
Coding an Error-Handling Routine
Using Inline Error Handling

Creating custom dialogue boxes with UserForms

Drawing UserForms
Setting UserForm properties, events and methods
Using text boxes, command buttons, combo boxes and other controls
Formatting controls
Applying code to controls
How to launch a form in code


List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video


Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel VBA Intermediate.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Reviews by course attendees

Average rating 4.8

Based on 178 reviews

Marc Holland; Internal Risk Analyst
Chris Giles; Financial Accountant
Neha Gorania; Cost Controller

Similar Courses

Request information

Find out more about this Excel VBA Intermediate course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here