VBA for Microsoft Excel training

Overview

Unlock the full programming potential of Excel with our VBA for Excel training course! This course is designed to empower you with the ability to automate tasks, create custom functions, and enhance Excel’s functionality using Visual Basic for Applications (VBA).

Whether you want to streamline repetitive processes, build dynamic tools, or integrate Excel with other applications, this course provides the knowledge and skills to harness VBA effectively. Perfect for professionals seeking to optimize their workflows or elevate their Excel expertise, this training will transform the way you work with data and productivity tools.

Microsoft Excel VBA training course in Melbourne and across Australia. We can come to you for Face-to-face Excel training or you can join us online for Live online Excel training courses.

Detailed Course Outline

Recorded Macros

- Setting Macro Security Levels

Recording A Simple Macro Running A Recorded Macro Relative Cell References Running A Macro With Relative Cell References Viewing A Macro Module Modifying A Recorded Macro

Recorder Workshop

Preparing Data For An Application
Recording A Summation Macro
Recording Consolidations
Recording Divisional Macros
Testing Macros
Creating Objects To Run Macros
Assigning A Macro To An Object

Using The VBA Editor

Opening And Closing The Editor
Working With The Project Explorer
Working With The Properties Window
Working With The Work Area
Working With A Code Module
Running Procedures From The Editor
Setting Breakpoints In The Editor
Stepping Through A Procedure

Understanding VBA

VBA Terminology
Accessing The Excel Object Model
Using The Immediate Window
Working With Object Collections
Setting Property Values
Working With Worksheets
Using The Object Browser
Programming With The Object Browser

Procedures

Creating A Command Procedure
Making Sense Of IntelliSense
Using The Edit Toolbar
Commenting Statements
Indenting Code
Bookmarking In Procedures

Using Variables

Creating And Using Variables
Implicit & Explicit Declarations
The Scope Of Variables
Procedure Level Scoping
Module Level Scoping
Passing Variables By Reference
Passing Variables By Value
Data Types
Declaring Data Types
Using Arrays

Using Excel Objects

Application Methods And Properties
Workbook Methods And Properties
Viewing Excel And The Editor Together
Using Workbook Objects
Worksheet Methods And Properties
Using Worksheet Objects
Range Methods And Properties
Using Range Objects
Project – Using Objects In Procedures

Programming Techniques

The MsgBox Function
Sending Messages To The User
InputBox Techniques
Using The InputBox Function
Using The InputBox Method
The IF Statement
Using IF For Single Conditions
Using IF For Multiple Conditions
The FOR NEXT Statement
Looping With Known Or Specified Iterations
The DO LOOP Statement
Looping With Unknown Iterations
Programming Techniques Quick Reference

Creating Custom Forms

Creating A Custom Form
Adding Text Boxes To A Form
Changing Text Box Control Properties
Adding Label Controls To A Form
Adding A Combo Box Control
Adding Option Buttons
Adding Command Buttons
Running A Custom Form

Programming Custom Forms

Initialising A Form Closing A Form
Project – Transferring Data From A Form
Running Form Procedures
Running A Form From A Procedure

Errors

Debug Errors
Error Traps
Dealing with Errors
Prevent Errors

Automatic / Event Procedures

Programming Automatic Procedures
Running Automatic Procedures
Automatically Starting A Workbook

Course prerequisites

Previous experience using Microsoft Excel at an Advanced level is an essential prerequisite for this course.

Inclusions

Instructor - led Training

Menual & Files

Unlimited Free Support

VBA for Microsoft Excel

Course Details

Duration 2 days

Level Advanced

Private Sessions

Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.

Enquire Now - Get a Quote

Public Sessions

Join a public course session conducted LIVE ONLINE via Microsoft Teams.

SKU: N/A Category: Excel

Detailed Course Outline

Recorded Macros

- Setting Macro Security Levels

Recording A Simple Macro Running A Recorded Macro Relative Cell References Running A Macro With Relative Cell References Viewing A Macro Module Modifying A Recorded Macro