Question: Create a new sub and an appropriately named button using Select Case to determine if any given cell in the Total Dollars Purchased column is

Create a new sub and an appropriately named button using Select Case to determine if any given cell in the Total Dollars Purchased column is less than $25,000, between $25,001 and $75,000 or above $75,000. Have the message boxes that tell us The Total Dollars Purchased is XXXXXX for each category, where the XXXXX is the range of possible outcomes for each category. Place the new button J14.
Create a sub and an appropriately named button that tells us the number of stores are in each Total Dollars Purchased category from the previous question. Place the button in cell J15.

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