Question: 2. (6 points) Write a sub that uses the Case Construction to do the following. If the mumber in cell B1 is at least 95,

 2. (6 points) Write a sub that uses the Case Construction

2. (6 points) Write a sub that uses the Case Construction to do the following. If the mumber in cell B1 is at least 95, a message box should say, "You're a star!" If it's between 90 and 94 (inclusive), a message box should say, "Well done!" If it's between 80 and 89 (inclusive), a message box should say, "Satisfactory performance. And if it's lower than 80, a message box should say, "Try again!" Go into Excel and insert a command button that hovers above B3:03. The button runs the sub and has the label "Feedback. 2. (6 points) Write a sub that uses the Case Construction to do the following. If the mumber in cell B1 is at least 95, a message box should say, "You're a star!" If it's between 90 and 94 (inclusive), a message box should say, "Well done!" If it's between 80 and 89 (inclusive), a message box should say, "Satisfactory performance. And if it's lower than 80, a message box should say, "Try again!" Go into Excel and insert a command button that hovers above B3:03. The button runs the sub and has the label "Feedback

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 Accounting Questions!