Aims

This course is designed for those who wish to gain a practical approach to developing VBA solutions and consolidate their existing knowledge.

Objectives

On completion of this course, attendees will have a more complete understanding of the Visual Basic techniques involved in customising and automating systems in Excel. As well as being able to ask questions on their own programming requirements.

Prerequisites

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

Versions

Courses are delivered in 2010, 2013, 2016, 2019 & O365

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

Training can be delivered at your offices in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

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)