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