ExcelVBATraining

Visual Basic Application (VBA) for Excel Training

by Tertiary Courses

These are the exercise files used for Visual Basic Application (VBA) for Excel Training course.

The course outline can be found in

https://www.tertiarycourses.com.sg/visual-basic-vba-excel-training.html

https://www.tertiarycourses.com.my/visual-basic-vba-excel-training.html

Module 1 Get Started on VBA

• What is VBA
• Access VBA from Excel
• Write Your First VBA Code
• Message Box and Input Box

Module 2 VBA Programming

• Variables and Constants
• Data Types and Array
• Operators
• Decision
• Loops

Module 3 Function and Sub Procedure

• Function
• Sub Procedure

Module 4 Managing Excel Objects

• Worksheet Object
• Workbooks Object
• User Form

Module 5 Event Handling

• Worksheet Events
• Workbook Events

Module 6 Mini VBA Project