clock icon

MON - FRI
9.00AM - 17.00PM

call icon

04 TRAINING
0487 24 64 64

VBA for Microsoft Excel

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

    • 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

  • 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
  • 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
  • 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
  • Creating A Command Procedure
  • Making Sense Of IntelliSense
  • Using The Edit Toolbar
  • Commenting Statements
  • Indenting Code
  • Bookmarking In Procedures
  • 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
  • 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
  • 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 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
  • Initialising A Form Closing A Form
  • Project – Transferring Data From A Form
  • Running Form Procedures
  • Running A Form From A Procedure
  • Debug Errors
  • Error Traps
  • Dealing with Errors
  • Prevent Errors
  • 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

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

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.

Public Sessions

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

Public sessions are unavailable at the moment. Please contact us to arrange one.

SKU: N/A Category:

Detailed Course Outline

    • 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

  • 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
  • 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
  • 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
  • Creating A Command Procedure
  • Making Sense Of IntelliSense
  • Using The Edit Toolbar
  • Commenting Statements
  • Indenting Code
  • Bookmarking In Procedures
  • 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
  • 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
  • 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 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
  • Initialising A Form Closing A Form
  • Project – Transferring Data From A Form
  • Running Form Procedures
  • Running A Form From A Procedure
  • Debug Errors
  • Error Traps
  • Dealing with Errors
  • Prevent Errors
  • 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

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

VBA for Microsoft Excel

Reviews

There are no reviews yet.

Be the first to review “VBA for Microsoft Excel”

Your email address will not be published. Required fields are marked *

Scroll to top