Receive our Newsletter





* = required field

Testimonials

Excellent and fast help and service. If you use Microsoft Excel you should get to know Katherine and her training can save your team huge amounts of time and make you all more efficient. Some of the things she taught me made me cry, as I'd been doing it the slow way for years before she showed me how to do it in seconds.
Charles Joynson, Wave Data and Gibli

Microsoft Excel VBA Level 2

Objective

By the end of this course you will be familiar writing VBA Excel Functions, deal with errors, and create forms.

Prerequisites:

A good working knowledge of Excel and be familiar with all topics on the Excel VBA Level 1 course.

Topics Covered:

Working with Visual Basic Code
  • Creating Functions
  • Public and private procedures
Variables and Error Handling
  • Variable Declaration options
  • Creating code to handle errors
  • Array Variables
 Customising user interface
  • Using Dialog boxes
  • Custom Forms
  • Using the data from the form

Duration:   1 Day

Delegates:  Maximum of 8

Course Cost: £1,000.00

Enter your email address to download Excel VBA Level 2 Outline