Question: Create a new macro-enabled workbook and save it as (FirstName] [LastName).xlsm (without the 0 symbols) Complete the two problems below on the same worksheet, and
![Create a new macro-enabled workbook and save it as (FirstName] [LastName).xlsm](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3002f223ca_32666f3002ea1237.jpg)
Create a new macro-enabled workbook and save it as (FirstName] [LastName).xlsm (without the "0" symbols) Complete the two problems below on the same worksheet, and then save and submit your workbook. Assign a button for each macro. Each macro should also receive its inputs through an input box and display its outputs through a msgbox. 1. Create a Sub called "Goodudgment that implements the flowchart below. Then, make it run by clicking a button. NOC Key NOC - Number of Cookies true false Display If you eat these, you will be sick NOC> 12 Display Your body can handle this End 2. Create a Sub called "daisyDecisions that runs when you click a button. In this subroutine, you will create a program that determines whether someone loves you, or loves you not. The program should receive, as an input, the number of petals on the flower (i.e., have a variable for petals) and then use that number determine the output of the program: if the number of petals is even, then the program should output that the person loves you not. If the number of petals is odd, then the person loves you. Hint: Use the Mod operator to determine if a number is odd or even: The Mod operator will return the remainder of one number divided by another, for instance: 11 Mod 2-1, 11 Mod 3 - 2, 11 Mod 4-3 You can also apply this operator on variables (ie, myVariable Mod 2 would return the remainder of your variable divided by 2). Be sure to write your code in a module in the workbook you will submit, not in your personal workbooks or sheets. To access the correct module, go to your "Visual Basic," right-click Microsoft Excel Objects" in the workbook you are submitting, and then click "Insert" and "Module
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
