Baseball Hit Problem

Input an integer number 1, 2, 3, 4, check to see if it is a single, double, triple, or home run

•1 – single
•2 – double
•3 – triple
•4 – home run

 display the type of hit: single, double, triple, or home run

 

Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdHit. Place the code under the Click event of a command button titled “Hit Type”.

Hint: Use a Select Case statement in the flowchart and the code.

 

Flowchart Solution

Sample Screen Shots

VBA Solution Code