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
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.
More in this category
Microsoft Excel
1 day
2 days
Microsoft Excel
2 days