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

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 General Management Questions!