Menu

Tel: 01423 534630    Email: info@tts-uk.com

Microsoft Excel VBA Introduction

Designed for Excel 365, 2019, 2016, 2013, 2010

Who is this course for?

This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.

Prerequisites

A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.

Benefits

By the end of the course the delegate will be competent in the fundamentals of VBA, including recording macros, working with the Visual Basic Editor and writing their own code.
In order to ensure minimal downtime while building and rolling out the program, the course also includes advice on debugging code and handling errors.


  • Course content

    Introducing Visual Basic for Applications

    Why use VBA?
    Recording and running macros
    Absolute v relative cell selection
    Working with the Visual Basic Editor

    Creating your own code

    Understanding and creating modules
    Defining procedures
    Calling procedures
    Where to store macros

    Making decisions in code

    Using logical comparisons
    The IF…ENDIF structure
    The SELECT CASE…END SELECT structure
    When to use IF v SELECT CASE

    Repeating code with loops

    The DO… LOOP structure
    The FOR… NEXT structure
    The FOR EACH… NEXT structure
    How to debug problems with loops

    Debugging errors

    Defining errors
    Setting breakpoints to pause execution
    How to step through code
    Working with break mode to spot errors
    Identifying the value of expressions

    Understanding Visual Basic

    What is an Object?
    Examining the Excel object hierarchy
    Using the object browser
    How to explore methods and properties
    Getting help in VBA

Duration: 1 day
Level: Introduction
Price: £395 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.