Question: PLEASE WRITE AS A SUB IN VBA CODE For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 68
PLEASE WRITE AS A SUB IN VBA CODE
For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 68 into cell B1.
Write a sub that uses the Case Construction to do the following. If the number in cell B1 is at least 95, a message box should say, Youre a star! If its between 90 and 94 (inclusive), a message box should say, Well done! If its between 80 and 89 (inclusive), a message box should say, Satisfactory performance. And if its lower than 80, a message box should say, Try again!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
