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,

  1. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!