Create a new macro-enabled workbook saved [FirstName]_[LastName].xlsm (without the "[]" symbols)
Discipline: Computer science
Type of Paper: Question-Answer
Academic Level: Undergrad. (yrs 3-4)
Paper Format: APA
Question
Create a new macro-enabled workbook saved [FirstName]_[LastName].xlsm (without the "[]" symbols)
Complete the following two problems below on the same worksheet and then save and submit your workbook
For each macro, assign it to a button. Each macro should also receive its inputs through an input box and display its outputs through a msgbox.
Create a Sub called "GoodJudgement" that implements the flowchart below and make it run by clicking a button
Expert Solution Answer
Code
Sub GoodJudgement()
Dim noc As Integer
noc = InputBox("Enter number of Cookies:")
If noc > 12 Then
MsgBox "If you are eat these, you will
be sick"
Else
MsgBox "Your body can handle
this"
End If
End Sub
How to add button and assign macro to it
step by step
output
If you have any query regarding the code please ask me in the comment i am here for help you. Please do not direct thumbs down just ask if you have any query. And if you like my work then please appreciates with up vote. Thank You.