Excel VBA Application $(13\%)$

A professional error$-$free and virus$-$free application built in MS Excel and VBA.

Assessment criteria of the application will be based on your ability to perform the

following task:

Use appropriate Excel functions and tools and$/$or charts to develop the basic model.

Write macros $($sub procedures$)$ using VBA in Microsoft Excel

Use appropriate data types to declare variables and$/$or constants

Use repetition, decision and$/$or selection structures in VBA code

Design professional$-$looking user forms to capture user input and perform data

validation

Use appropriate event procedures for some Excel and VBA objects

Use other objects, e$.$g$.$ chart, pivot table, as necessary