Microsoft Excel VBA

Harness the power of VBA to manage large and variable amounts of data.

Learn best practice for writing and editing VBA code and improve your data's usability.

3

Reviews

9.3

Satisfaction

100.0%

Recommend
Communal3

Microsoft Excel VBA

Microsoft Excel VBA

This VBA and Excel course will unlock the power of coding in Excel. Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity.

Dive into the world of Visual Basic for Applications (VBA) and gain the skills to write custom code that extend Excel's functionality. Discover the art of coding with VBA as you build interactive applications, manipulate data, and control Excel objects.

This course will equip you with the knowledge and tools to harness the full potential of VBA in Excel.

Duration icon

Two Days

Timings icon

10:00 - 16:30 GMT

  • Key Learning Points

  • icon Automate tasks with Macros
  • icon Create custom functions and procedures
  • icon Manipulate objects and properties
  • icon Expressions, variables, and functions
  • icon Working with forms and controls

If attending an online course you must have a licensed copy of any software required and access to a suitable computer.

You'll need to have attended our Excel Advanced course or have equivalent working knowledge before joining this class.

Our Expert Team
Expert Trainers

Course leader is an experienced industry expert

No in-person dates available at the moment.
No online dates available at the moment.
Media Training

Request a quote for Microsoft Excel : VBA

All our courses are available as private, bespoke or team training.

You can customise the outline, have a group where it's just your team or enjoy a one to one session with an expert.

We can deliver the course at our centre, live online or at your choice of venue.

Fill in the form below and our team will get in touch with pricing and helpful advice to get the conversation started.

Course Dates

Course Outline

1

Getting Started

Displaying the Developer Tab

Recording and running a Macro

Macro-Enabled Workbooks

Using the Visual Basic Editor

The Development Environment

Understanding Macro Security

2

Working with Procedures and Functions

Understanding Modules

Understanding Procedures

Calling Procedures

Creating a Function Procedure

Working with the Code Editor

3

Understanding Objects

Objects and Collections

Working with Properties

Using the With Statement

Creating an Event Procedure

4

Using Expressions, Variables, and Intrinsic Functions

Understanding Expressions and Statements

Declaring Variables

Understanding Data Types

Using Intrinsic Functions

Understanding Constants

Declaring and using Object Variables

5

Controlling Program Execution

Control-of-Flow Structures

Working with Boolean Expressions

Different types of Control-of-Flow structures

Guidelines for use of Control-of-Flow Structures

6

Working with Forms and Controls

Working with UserForm Properties, Events and Methods

Working with different Controls

SettingControl Appearance

Populating a Control

Adding Code to Controls

Launching a Form in Code

7

Handling Errors

Understanding Error Handling

Writing an Error-Handling Routine

Working with Inline Error Handling

Who attends?

Career Progressives icon

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Career Changers icon

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Graduates icon

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Learn Your Way

Face to Face

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Live Online

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Team Training

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Three Steps To Success

1

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

2

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

3

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.