Professional Training
4.8 (488 Reviews)

Excel VBA Intermediate

STL, In London (+21 locations)
Length
1 day
Price
300 - 325 GBP excl. VAT
Next course start
30 July, 2024 (+40 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
300 - 325 GBP excl. VAT
Next course start
30 July, 2024 (+40 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel VBA Intermediate

STL courses

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

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 40 start dates

30 July, 2024

  • Classroom
  • London
  • English

14 October, 2024

  • Virtual Classroom
  • Online
  • English

20 November, 2024

  • Virtual Classroom
  • Online
  • English

21 November, 2024

  • Classroom
  • London
  • English

2 January, 2025

  • Virtual Classroom
  • Online
  • English

31 January, 2025

  • Classroom
  • London
  • English

4 March, 2025

  • Virtual Classroom
  • Online
  • English

14 April, 2025

  • Classroom
  • London
  • English

15 April, 2025

  • Virtual Classroom
  • Online
  • English

21 May, 2025

  • Classroom
  • London
  • English

22 May, 2025

  • Virtual Classroom
  • Online
  • English

30 June, 2025

  • Virtual Classroom
  • Online
  • English

4 August, 2025

  • Classroom
  • London
  • English

5 August, 2025

  • Virtual Classroom
  • Online
  • English

11 September, 2025

  • Virtual Classroom
  • Online
  • English

16 October, 2025

  • Classroom
  • London
  • English

20 October, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

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

Expenses



List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact form

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

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

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.

Reviews by course attendees

Average rating 4.8

Based on 488 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Mohamed Consultant
27 Nov 2023

Most useful topic: Functions

5/5
Mark Finance Director
15 Nov 2023

Another great coursed - Jens is an excellent tutor

5/5
Gabriela Analyst
15 Nov 2023

Most useful topic: functions writing

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads