Dive into the transformative world of Visual Basic Application (VBA) for Excel with our specialized training course. Participants will gain hands-on experience working in the Visual Basic Editor, adding and optimizing code for macros, and effectively managing code modules. The curriculum further illuminates the nuances of declaring and utilizing variables, the intricacies of variable scope, and the power of defining arrays.

Delving deeper, the course also focuses on masterfully managing workbooks and worksheets using VBA, automating repetitive tasks with loops, and employing advanced debugging techniques. Additionally, the training sharpens skills in managing cell data operations and proficiently running event procedures. Equip yourself with the expertise to harness the full potential of Excel using VBA with Tertiary Courses.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M379

Topic 1 Get Started on VBA

• What is VBA

• Access VBA from Excel

• Write Your First VBA Code

• Message and Input Box

• Macro Record

Topic 2 VBA Programming

• Variables and Constants

• Data Types and Array

• Operators

• Decision

• Loops

Topic 3 Function and Sub Procedure

• Worksheet Functions

• Create Charts

• Sub Procedure

Topic 4 Managing Excel Objects

• Work with Excel Objects

• Error Handling

• Debugging

Topic 5 Events and User Forms

• Events

• User Forms