0845 450 6120

Excel VBA Intermediate

Who is this course for?

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

Benefits

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

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

We don't currently have any courses listed for Excel VBA Intermediate, would you like to view all courses for Microsoft Office?

Learning Objectives

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

Pre-Requisites

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

Course Content

Course Syllabus

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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include