Automating Tasks with Microsoft Excel VBA

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme teaches clerks, officers, executives and managers how to use Excel as a development tool, with Visual Basic for Applications (VBA) code that automates tasks and builds custom applications.

It starts with four commonly used Excel objects: Application, Workbook, Worksheet and Range. Participants then write VBA in the Visual Basic Editor with variables, message and input boxes, branching and loops, and design user forms with controls such as list boxes and combo boxes. A debugging session covers breakpoints and the Immediate, Locals and Watch windows.

A case study project at the end brings it together, and participants leave ready to start building their own custom applications and interfaces in Excel.

Module topics

  • Excel objects, properties and methods
  • VBA and the Visual Basic Editor
  • Variables, branching and loops
  • Worksheet-based forms and controls
  • Debugging techniques
  • Case study project

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

Subashkaran Perumalu

Excel, Power BI and programming trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry