Question: Write a sub using VBA in Excel (in a MODULE ) called HW10_Num1 that will determine if your Project 1 assignment earns you a token,
- Write a sub using VBA in Excel (in a MODULE ) called HW10_Num1 that will determine if your Project 1 assignment earns you a token, costs a token or has no impact, using one or more if statements.
Here are the rules:
- If the assignment was submitted on time and your score is 90 or above, you earn a token.
- If the assignment was submitted on time and your score is less than 90, there is no change in your token count.
- If the assignment was submitted late, you lose a token.
Here is the beginning of pseudocode:
- Ask the user if the assignment was on time or late in some way using an input box.
- If it was on time, then ask the user what score was earned using an input box. If they enter anything other than a number from 0 to 100, treat the score as 0. (if it was late, dont ask for the score)
- Use the entered information to determine the change in tokens.
- Report the result in a message box.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
