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 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
Get step-by-step solutions from verified subject matter experts
