Aims

This course is designed to introduce the macro recorder and the VBA editing environment.

Objectives

Delegates will learn how to write simple procedures and modify recorded code. The course is suitable for those who need to create VBA procedures from scratch and those who have inherited more complex ones and need to understand how they work. The course also provides the foundation for developing your VBA skills further on stage 2.

Prerequisites

Attendees should have a very sound knowledge of Excel and be a regular user.

Versions

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

What will I learn?

Overview

  • VBA or Macros?
  • What it can be used for

Getting Started

  • Developer tab
  • Filing
  • Macro Security

Using the Recorder

  • Naming Macros
  • Assigning Shortcuts
  • Absolute and Relative Recording
  • Where macros are stored
  • Personal Macro Workbook

Running Macros

  • Shortcut keys
  • Quick Access Toolbar
  • Worksheets buttons and shapes
  • Ribbons

The VB Editor

  • Overview of the VB Editor
  • Projects and the Project Explorer
  • Properties and Code Windows

Editing Code

  • Understanding the code structure
  • Simple edits
  • Calling procedures

Stepping and Debugging

  • Step Intro, Over, Out
  • Setting Breakpoints
  • Editing code while Stepping
  • Dealing with Runtime errors

Writing Macros & VBA Terminology

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

Exploring Code with the Immediate Window & Variables and Constants

  • Dimensioning
  • Option Explicit
  • Data Types
  • Scope
  • Locals and Watch Windows

The If statements

  • Single line
  • Blocked If
  • Logical expressions

Adding simple Interactivity to Macros

  • Creating an Interactive Message Box
  • Creating a Custom Input Box

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)