HOME
 

Excel VBA Intermediate

STL
Course summary
Length: 1 day
Price: 199 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 01/02/2019 09:30 - London
Rating: (178 Reviews)
Course Dates
London
01/02/2019 09:30  (English)
199 GBP
01/03/2019 09:30  (English)
199 GBP
25/04/2019 09:30  (English)
199 GBP
08/05/2019 09:30  (English)
199 GBP
16/05/2019 09:30  (English)
199 GBP
24/05/2019 09:30  (English)
199 GBP

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

Expenses



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

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


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

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.

Contact information for STL

STL

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

 Show phone number
www.microsofttraining.net


Reviews by course attendees

Neha Gorania; Cost Controller   |   22/06/2016
          (5)
Oliver Barnes; Revenue Controller   |   22/06/2016
Most useful topic: Pretty much everything!
          (5)
Marc Holland; Internal Risk Analyst   |   22/06/2016
          (4)
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 first annual U.K. L&D Report!

UK 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