Excel VBA Intermediate

STL
4.3
13 reviews
  • Given incredible assets, and bolstered all through with great illustrations. can truly take this into my work.
    ← | →
  • Exceptionally learned and energetic moderator made the diligent work of comprehension a perplexing agreeable subject.
    ← | →
  • The VBA foundation and transitional classes were both perfectly arranged and nicely instructed. The sessions included pragmatic activities which was an incredible approach to comprehend. Moreover the arrangement of materials after the classes has permitted me to keep rehearsing what I have studied and will better set me up for the propelled course.
    ← | →

Course

In London

£ 201-500

The best Excel courses

See all

See all

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

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

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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.

A beginners knowledge of Microsoft Excel VBA is required, or completion of our Excel VBA Introduction course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • Given incredible assets, and bolstered all through with great illustrations. can truly take this into my work.
    ← | →
  • Exceptionally learned and energetic moderator made the diligent work of comprehension a perplexing agreeable subject.
    ← | →
  • The VBA foundation and transitional classes were both perfectly arranged and nicely instructed. The sessions included pragmatic activities which was an incredible approach to comprehend. Moreover the arrangement of materials after the classes has permitted me to keep rehearsing what I have studied and will better set me up for the propelled course.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

M. Sutton

4.5
28/02/2016
What I would highlight: Given incredible assets, and bolstered all through with great illustrations. can truly take this into my work.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Wilkinson

5.0
14/01/2016
What I would highlight: Exceptionally learned and energetic moderator made the diligent work of comprehension a perplexing agreeable subject.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Karishma

4.0
24/10/2015
What I would highlight: The VBA foundation and transitional classes were both perfectly arranged and nicely instructed. The sessions included pragmatic activities which was an incredible approach to comprehend. Moreover the arrangement of materials after the classes has permitted me to keep rehearsing what I have studied and will better set me up for the propelled course.
What could be improved: N/A.
Would you recommend this course?: Yes

Tony B.

3.5
29/09/2015
What I would highlight: The course is fantastic for getting and well goes with the fundamentals. Profoundly suggest the course and the teacher loves VBA and you will leave the course adoring it as well
What could be improved: Nothing.
Would you recommend this course?: Yes

Mig

4.5
25/09/2015
What I would highlight: This is the most wonderful course I have been on for 10 years. The mentor was efficient, educated, positive and enthusiastic and kept the course moving along rapidly enough to keep everybody tried and agreeable. He even had additional activities for the quick ones. As a college teacher I have a lot of understanding and have as of now began prescribing it to associates and am reserving myself onto the following course.
What could be improved: Everything OK.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Handling Errors
  • Storing information
  • Private scope
  • Creating functions
  • User Defined Functions
  • Excel
  • Message Boxes
  • Input Boxes
  • UserForms
  • Formatting controls

Course programme

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




Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Excel VBA Intermediate

£ 201-500

The best Excel courses

See all

See all