Microsoft Excel VBA & Macro Training Course

Our Microsoft Excel VBA & Macro Training Course is a 2-day programme designed to help participants understand VBA programming and automate repetitive tasks in Microsoft Excel. The training covers macro recording, the VBA Editor, programming procedures, variables, custom functions, Excel objects, conditional statements, loops, UserForms and error handling. Participants will learn how to create basic macros, develop VBA code and customise Excel workbooks to support everyday spreadsheet activities.

The course is suitable for participants who are new to VBA programming but already have basic knowledge of Microsoft Excel. Previous coding or programming experience is not required. However, participants should already understand Excel worksheets, formulas, functions and basic data handling. The training begins with recording macros and fundamental VBA concepts before progressing to programming techniques and custom forms.

Microsoft Excel Advanced focuses on developing higher-level spreadsheet skills using Excel's built-in functions and features. Excel VBA & Macro focuses on using programming techniques to automate repetitive spreadsheet tasks and create customised Excel functionality. Participants will learn how to record macros, write VBA code, create procedures, work with Excel objects and develop interactive UserForms. Excel VBA & Macro is suitable for users who already understand Excel fundamentals and want to move into spreadsheet automation.

The uploaded course outline does not state that completing Microsoft Excel Advanced is compulsory. However, it requires participants to have prior knowledge of Excel 2013 concepts, and the course website recommends understanding Excel formulas, functions and data handling. Participants who already have sufficient Excel experience may be able to join without completing the Advanced course. Those who need to strengthen their Excel foundation can first consider Microsoft Excel Basics, Intermediate or Advanced training.

An Excel macro is a recorded or programmed sequence of actions that can be run to perform tasks automatically. VBA, or Visual Basic for Applications, is the programming language used to create and modify macros in Microsoft Excel. Recording a macro allows users to automate a series of Excel actions without writing all the code manually. Learning VBA enables users to develop more customised procedures, functions and forms beyond basic recorded actions. The course covers both macro recording and VBA programming.

Yes. Day 1 includes a dedicated module on introducing Excel macros. Participants will learn how macros work, understand macro security settings and save macro-enabled workbooks. The module also covers recording a simple macro and running a recorded macro. These fundamentals prepare participants for learning VBA programming during the remaining modules.

Yes. Day 1 includes a module dedicated to the VBA Editor. Participants will learn how to open and close the Editor, navigate the Project Explorer, use the Properties Window and work with code modules. The course also introduces running code from the Editor, setting breakpoints and stepping through code. These techniques help participants understand how VBA programs are created, examined and

Yes. Day 1 includes a dedicated module on Using Variables. Participants will learn how variables are created and used, understand implicit and explicit declarations and explore different variable scopes. The module also covers passing variables by reference or value, declaring data types and using arrays. These concepts help participants understand how VBA programs store and manage information.

Yes. The final module on Day 1 focuses on Functions in VBA. Participants will learn how to create functions, set data types, use multiple arguments and modify existing functions. The programme also covers creating and referencing function libraries, importing VBA modules and using functions within VBA code. Participants will be introduced to using custom functions directly in Excel worksheets.

Yes. Day 2 includes a module on Using Excel Objects. Excel objects represent elements of the Excel application, such as workbooks, worksheets and cell ranges. Participants will learn about the Application Object, Workbook objects, Worksheets Object and Range Object. The training also covers using these objects within VBA procedures to interact with Excel files and worksheet information.

Yes. Day 2 includes modules on Creating Custom Forms and Programming UserForms. Participants will learn how to create forms and add controls such as text boxes, labels, combo boxes, option buttons and command buttons. They will also learn how to initialise forms, handle events and transfer data from forms. These skills are relevant to developing customised Excel data entry and user interaction tools.

The programme teaches the programming concepts and tools needed to automate repetitive Excel operations. Participants will learn macro recording, VBA procedures, Excel objects, variables, functions and programming techniques. These skills can be applied to routine spreadsheet activities, including recurring calculations and data processing. The uploaded PDF does not specify a dedicated automated reporting project, so the exact workplace applications should be discussed with the trainer if required.

Excel VBA macros cannot be created, edited or executed directly in Excel for the web. Participants need a compatible desktop version of Microsoft Excel to practise the VBA programming techniques covered in this course. Excel for the web can open certain workbooks containing macros, but macro execution requires the desktop application. Organisations arranging online training should ensure participants have suitable Excel desktop software installed.

The course takes two days, with sessions normally running from 9:00 AM to 5:00 PM. Day 1 focuses on Excel macros, VBA fundamentals, the VBA Editor, procedures, variables and custom functions. Day 2 covers Excel objects, programming techniques, custom forms, UserForm programming and error handling. Training includes guided coding exercises, demonstrations and hands-on Microsoft Excel activities.

The current CAD Training Centre training schedule lists Microsoft Excel VBA & Macro as in-house training only. The programme can be arranged for corporate groups, subject to trainer availability and quotation requirements. Companies can contact our training team to discuss the number of participants, preferred dates, training venue and delivery arrangements. Individual public enrolment is not currently confirmed.

Yes. CAD Training Centre offers corporate and in-house training arrangements. Organisations can discuss their existing Excel skill levels, learning objectives and workplace automation requirements with our training team. The standard course outline covers macro recording, VBA programming, Excel objects, UserForms and error handling. Any requested customisation is subject to agreement with the trainer and confirmation of the training scope.

The current training schedule lists Excel VBA & Macro as an in-house programme for groups of five or more participants. For cost-effectiveness, groups of 8–10 participants are generally recommended. Smaller groups may be considered, subject to the applicable minimum group quotation. The final class size and training arrangements will depend on the organisation's requirements and the trainer's recommendations.

In-house training may be arranged at your company's premises, a suitable training venue or CAD Training Centre in Bandar Puteri, Puchong. The training venue should provide suitable equipment and access to Microsoft Excel for practical VBA programming exercises. Training dates, location and equipment requirements will be confirmed when preparing the corporate quotation.

No need to bring your own laptop or licence. We provide a laptop with the software installed for class use. This applies to training conducted physically at CAD Training Centre in Puchong. For in-house training conducted at a client's premises or another external venue, laptop provision and Microsoft Excel licensing arrangements should be confirmed before the programme. Participants using their own laptops should have a compatible desktop version of Excel installed.

Yes. The CAD Training Centre course website advertises a Certification of Achievement after completing Excel training. Participants attending the Excel VBA & Macro programme can receive a certificate upon successful completion of the training. The final certificate arrangements for a private corporate programme should be confirmed with the training team.

The training is conducted bilingually in English and Bahasa Melayu.

Yes. Our Microsoft Excel VBA & Macro Training Course is HRD Corp claimable, subject to applicable eligibility and grant approval requirements. Eligible Malaysian employers may apply for HRD Corp training grants for their employees. CAD Training Centre can provide the relevant course documents and quotation to support the organisation's grant application.

Yes. CAD Training Centre has a surau available at our training centre in Bandar Puteri, Puchong. For in-house training conducted at a client's premises or another external venue, prayer room facilities will depend on the selected location. Organisations can confirm the available facilities when arranging their training.

Classroom training means physical attendance at the agreed venue, with face-to-face guidance and hands-on practice using Microsoft Excel. Live online training via Zoom may be arranged for corporate groups, subject to trainer availability and agreement on the practical exercises. Participants joining online must have a compatible desktop version of Excel that supports VBA. The programme is currently listed as in-house only, so online delivery arrangements require confirmation before booking.