ExcelVBATraining

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

The course outline can be found in

https://www.tertiar**ycourses.co*m.sg/visual-basic-vba-excel-training.html

https://www.tertiarycourse*s*.c*om.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