Aims & Objectives

Our Microsoft Excel VBA Stage 3 course is an advanced course that helps you further develop your VBA programming skills. You’ll gain a more complete understanding of the Visual Basic techniques involved in customising and automating systems in Excel and learn to ask questions on your own programming requirements.

To attend you should have attended our VBA Stage 1 and VBA Stage 2 courses or have equivalent experience. Ideally attendees will have had a chance to put into practice some of the techniques covered in the stage 1 and 2 courses.

What will I learn?

Arrays

  • Creating and Defining Arrays
  • Assigning Values to an Array
  • Filling Arrays Using Loops
  • Dynamic Arrays
  • Preserving Array Value

Error Handling & Trapping

  • Error Handling Code
  • Trapping Errors with Error Numbers

Event Procedures

  • Events Associated with Worksheets
  • Events Associated with a Workbook

Custom User Forms and Form Controls

  • User-Defined Forms
  • Adding Controls to a Form
  • Form Controls Design Tools & Techniques
  • Form Control Properties
  • Programming a User Form
  • Displaying a User Form
  • Using ActiveX Controls directly on a Worksheet

Filing

  • Filing commands
  • The Dir() function
  • FileSystemObject

Development Techniques

  • Tips and tricks for developing a VBA solution

Coding Charts

  • Creating Charts
  • Sizing and Positioning Charts
  • Naming Charts
  • Adding, modifying and deleting Series
  • Formatting Charts

Coding Pivot Tables

  • The Pivot Cache and Pivot Table Objects
  • Creating a Pivot Table
  • Naming Pivot Tables
  • Manipulating Pivot Table Fields
  • Refreshing Pivot Tables

Interacting with Other Office Applications

  • Communicating with Word and PowerPoint using Excel VBA

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)