Question
Step 1: Gather Inputs and Validate Numbers Write a macro that asks how many people are coming to your party and assign the input to
Step 1: Gather Inputs and Validate Numbers
Write a macro that asks how many people are coming to your party and assign the input to a variable. Next, the macro will ask how many slices of pizza each person will eat and assign the input to a new variable. Finally, the macro will ask how many slices of pizza will be ordered and assign the input to a new variable. If any of the inputs is not a number (Hint: use IsNumeric() function to check) , have a message pop up with a critical sign indicating that the input was invalid.
Step 2: Calculation and Give Feedback
If all three inputs are valid, make calculation to decide if enough slices have been ordered. If yes, have a message box pop up which indicates the number of slices ordered, the amount each person can eat, and how many slices will be left over. If not, have a message box pop up indicating that ordered amount of slices wasnt enough and how many more slices you will need to order.
Assign your macro to a command button that has HW 3.1 and your name written on it. All input and message boxes should look similar to the samples boxes on the following page.
Turn in a word document that includes your command button and the input/messages boxes with results for different responses. It should look similar to the next page.
The values used on the first and second examples were respectively (100, 1, 150) and (50, 4, 80).
You do not need to use the same wording or number values shown on the example page,
But make sure to:
Include the same box titles (use your name, not Victors)
Include the corresponding critical, information, and exclamation signs
Use two lines in message boxes
(e.g. line 1: number of slices of pizza ordered; line 2: number left over / need to reorder)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started