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.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
