Is Excel VBA training HRDF claimable?

Yes, Excel and Microsoft Office skills training from HRD Corp registered providers is claimable.

What is the difference between recording a macro and writing VBA?

Recording captures your actions as VBA code automatically — great for simple tasks. Writing VBA allows logic, loops, and conditions that recorded macros cannot achieve.

How long is Excel VBA training?

Most programs run 2 days. Advanced programs covering complex object models may run 3 days.

Back to Digital Skills Training

Excel VBA & Macros Training Malaysia (2026) — HRDF Claimable

60 providers•29 with listed programmes•HRDF Claimable•Updated March 2026

Excel VBA (Visual Basic for Applications) is the programming language built into Excel that allows you to automate almost any repetitive task — from formatting and data cleaning to generating reports and interacting with other Office applications.

View All Providers

Quick Answer: Excel VBA & Macros Training

What is it: Training to write, record, and debug Excel VBA macros — automating repetitive tasks, building custom functions, creating user forms, and generating automated reports.

Who is it for: Finance professionals, accountants, business analysts, operations staff, and any Excel-heavy user.

Typical cost: RM2,500–RM5,500 for a 2-day program.

What You'll Learn

Record and edit macros to automate repetitive formatting and data tasks
Write VBA code to build custom functions and automated workflows
Create user forms for structured, error-free data entry
Generate automated reports that refresh at the click of a button
Interact with other Office applications — Outlook, Word, Access — via VBA

Who Should Attend

Finance and accounting teams, business analysts, operations staff, HR professionals managing large datasets, and anyone who spends significant time on repetitive Excel work.

Full Curriculum: What This Training Covers

That's the outcome — here's exactly how we get you there, module by module. A typical programme is organised into these modules; content is tailored to your team, roles, and industry.

1.Recording & Running Macros

Setting macro security, saving a macro-enabled workbook, recording a simple macro with the macro recorder, then running, viewing, editing and deleting it, plus assigning macros to keyboard shortcuts, toolbar buttons and worksheet objects.

2.Macro Recorder Workshop

Applying the recorder to real repetitive office tasks such as preparing data, updating opening balances and importing text files, then attaching the recorded macros to buttons and shapes to run them.

3.The VBA Editor & IDE

Navigating the Visual Basic Editor and its major IDE components — the Project Explorer, Properties window and code modules — and opening, closing and stepping through procedures.

4.Understanding VBA & the Excel Object Model

Core VBA terminology and syntax, how objects, properties, methods and collections work, using the Immediate window and Object Browser to inspect the Excel object model.

5.Working with Range & Worksheet Objects

Referencing and manipulating Application, Workbook, Worksheet and Range objects, using the Cells method to select single or multiple ranges, and performing multiple actions on an object in a procedure.

6.Procedures & Variables

Writing Sub and command procedures with IntelliSense, commenting and indenting code, then declaring variables and data types and managing local, module-level and public scope (passing by reference vs by value).

7.Control Structures & Loops

Directing program flow with If-Then-Else conditions and repeating code using For-Next and Do-Loop structures for both known and unknown numbers of iterations.

8.Dialogs, Forms & Error Trapping

Interacting with users through the MsgBox and InputBox functions, then identifying error types, using Break mode and writing error-handling routines to produce reliable, error-free macros.

Get Free Quotes for Excel VBA & Macros Training

Compare quotes from verified excel vba & macros training providers in Malaysia. Tell us your requirements and receive customized proposals within 24 hours.