These are the exercise files used for NICF – Software Automation with Excel VBA Programming course.
The course outline can be found in
https://www.tertiarycourses.com.sg/wsq-vba-course.html
Topic 1 Get Started on VBA
- What is VBA
- Access VBA from Excel
- Write Your First VBA Code
- VBA Macro
Topic 2 VBA Programming
- Variables and Constants
- Data Types and Array
- Operators
- Decision
- Loops
Topic 3 Function and Sub Procedure
- Function
- Sub Procedure
Topic 4 Managing Excel Objects
- Excel Objects
- Testing and Debugging
Topic 5 Create User Defined Forms
- • User forms
- • Events and Event Procedure
Mode of Assessment
- Written Assessment(Q&A)
- Practical Performance