You must not change the appearance of the provided Userform and the properties of any controls on the Userform at design time or runtime unless you are told explicitly to do so$.$

$$ You may enter your code into the included subs, but you must not change the code that

is already contained in these subs.

$$ You must specify all utilised properties of Userform controls properly in your code. For

example, the Value property of TextBox$1$ must be specified as TextBox$1.$Value. Missing

the property specification will be considered an error.

$$ Unless the assigned value of a variable is needed again by any subs while the application

is still running, it must be declared inside the sub that uses the variable. If the value of a module$-$level variable is not to be reused by more than one sub, it will be considered an error.

$$ Redundant statements $($including irrelevant statements or statements not associated with the listed tasks$)$ will be considered errors.

$$ All code must be processed sequentially according to the order imposed by the task list. That is$,$ Task $1$ai must be executed before Task $1$aii. Code not executed in the required task order will be considered an error.

$$ Marks will be deducted for the poor layout of the code. That includes non$-$properly named or declared variables, poor flow of the program, lack of comment statements, low readability, etc.

$$ The assignment is not a team assignment. You are expected to complete the assignment by yourself. Discussions between classmates are encouraged, but you must not cross the line between discussion and plagiarism $($such as sharing the answer in any way$).$You must not change the appearance of the provided Userform and the properties of any controls on the Userform at design time or runtime unless you are told explicitly to do so$.$

$$ You may enter your code into the included subs, but you must not change the code that

is already contained in these subs.

$$ You must specify all utilised properties of Userform controls properly in your code. For

example, the Value property of TextBox$1$ must be specified as TextBox$1.$Value. Missing

the property specification will be considered an error.

$$ Unless the assigned value of a variable is needed again by any subs while the application

is still running, it must be declared inside the sub that uses the variable. If the value of a module$-$level variable is not to be reused by more than one sub, it will be considered an error.

$$ Redundant statements $($including irrelevant statements or statements not associated with the listed tasks$)$ will be considered errors.

$$ All code must be processed sequentially according to the order imposed by the task list. That is$,$ Task $1$ai must be executed before Task $1$aii. Code not executed in the required task order will be considered an error.

$$ Marks will be deducted for the poor layout of the code. That includes non$-$properly named or declared variables, poor flow of the program, lack of comment statements, low readability, etc.

$$ The assignment is not a team assignment. You are expected to complete the assignment by yourself. Discussions between classmates are encouraged, but you must not cross the line between discussion and plagiarism $($such as sharing the answer in any way$).$

Please see the image for the question.