Aims & Objectives

Our Microsoft Excel VBA Stage 2 course builds on the knowledge and understanding of VBA gained from attending our Stage 1 course.

You’ll learn how to write procedures to develop efficient and practical VBA solutions, how to manipulate the Range object and create procedures which automate repetitive tasks and how to write and use Function procedures.

To attend this course you should have attended our VBA Stage 1 course course or have equivalent experience.

What will I learn?

Loops

  • The concept of looping
  • Different types of loop
  • For – Next Loop
  • Do – Loop
  • For Each Loop

Collections and Object Hierarchy

  • A closer look at how objects are organised

Exploring the Range Object

  • Referring to a Range
  • Collections and Items
  • The CurrentRegion Property
  • The Offset & Resize Properties

Calling Sub Procedures

  • Defining arguments in called procedures

User Defined Functions

  • Using Excel Worksheet Functions in VBA
  • VBA Functions
  • User-Defined Functions
  • Declaring Variables in User Defined Functions
  • Using Ranges in User Defined Functions

Writing Macros

VBA Terminology

  • Procedures, Subroutines, Macros, Functions
  • Objects, Methods, Properties

Further Testing and Debugging Techniques

  • Types of Error and Debugging
  • Stepping Through a Procedure
  • Monitoring Variable Values
  • Break Mode
  • Testing and Debugging Code
  • Watch & Immediate Window

How We Deliver

We currently deliver all training online to comply with the Government's guidelines.

Online training works well for businesses whose staff are mainly working from home.

It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.

Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.

When permitted we also offer face to face training at your offices.

All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)