Training at Blue Novation



Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Introduction to Excel VBA 

This course will show delegates how to use the Visual Basic for Applications (VBA) programming language to simplify and automate many of the repetitive tasks that are part of spreadsheet development.

Course Topics

Recording Macros

using the macro recorder • running macros via worksheet or toolbar buttons • relative and absolute cell references • options for storing a macro

Visual Basic Editor (VBE) Window

familiarisation with the VBE window • excel objects, user forms & modules • procedures, keywords, statements & comments • customising the VBE window

Creating and Modifying VBA Code

making long statements readable • using message boxes to interact with the user • using input boxes to get information from the user

Working with Worksheets and Cells

navigating around worksheets • editing & formatting cells • moving around lists of data • working with named ranges

Introducing Functions and Variables

variables and variable types • using a naming convention for your variables • using built-in worksheet functions

Decision Making within VBA Procedures

using If Then Else statements • using Select Case statements

Looping Through Data

using Do While or Do Until statements • exploring the use of the For Next statement

De-Bugging your Code

break mode • stepping through code • using auto data tips, call stack, expressions • using the immediate window, local window

On-sheet Controls

using “controls” on the worksheet • setting the properties of controls • linking controls to the worksheet 

Working with Workbooks 

opening other workbooks with re-usable code • navigating between different workbook • saving a workbook file

Creating Re-usable Code

passing arguments to a procedure • exploring the benefits of re-usable code

Handling Errors within your Code 

trapping errors adding code to handle the errors • determining what error has occurred • exiting from the error handling code

Variables and their scope and lifetime

testing the content of a variable  local, module and static variables global and private variables using constants

Working with Data 

manipulating data contained within a single string • manipulating dates

Creating User Defined Functions 

creating a simple function • creating a function for a more complex formula you use frequently

User Forms

how to create simple custom forms in Excel • adding controls to a user form  adding code to respond to events

Good Coding Guide



Follow on Course

1-day Excel VBA Advanced

Course Dates

Course Dates

Classroom: Postponed due to Covid restrictions
Online: Please contact us for details

Bring Your Own Device Option

All classroom based scheduled training sessions are BYOD (bring your own device) courses. Don’t have a laptop? No worries, we can provide a PC for training.

Course Duration

Classroom: 2 days
Online: 4 sessions

Scheduled Course Fee

£500 + VAT

Class Size

Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates


Classroom: Ipswich or onsite at clients premises


The 2-day Introduction to VBA is for people with a good working knowledge of Excel. No prior knowledge of Excel macros or VBA is required.

Training Formats

Scheduled course · private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)


A comprehensive course manual provides support throughout the course. Available in PDF format for Online sessions.


learner testimonial

“There was a good balance between theory and practical examples with a chance to explore work based solutions among the group. Excellent next step from advanced Excel.”

Steve Roberts, Group Reporting Analyst
Movac Group


learner testimonial

“Thoroughly enjoyed the VBA course. Excellent tutor who really knows his stuff!”

Nathan Jennings, Finance Manager

Not found the course you are looking for?


We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

Blue Novation - bespoke software and training solutions


G6, The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE

Please contact us by email:

or by using the contact us form