Question: In Excel VBA, please type code that will play the game rock paper scissors with a user. Call the Macro RoShamBo. The player will need

In Excel VBA, please type code that will play the game rock paper scissors with a user. Call the Macro "RoShamBo." The player will need to be asked to pick either rock paper or scissors. Then, the code will need to generate a random number using Randomize on a line and then use the built-in function Rnd for the line underneath it. This will generate values 0 to 1.

The randomly generated values of .33 and less will be rock, the numbers between .33 and .66 will be scissors and values greater than .66 will be paper. Please put the "Your Pick" in cell A1, "Computer Pick" in B1, and "Outcome" in cell C1. All of their respective values should be displayed underneath.

IPO

input: 1. Player chooses rock, paper or scissors

Processing: 1. Obtain input from user. 2. Generate a random number from 0 to 1. 3. Code determines the winner. 4. Put the results onto the spreadsheet.

Output: 1. Player choice 2. Computer Choice. 3. Winner

If it runs correctly, I will thumb up. Needs to be in Excel VBA.

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 General Management Questions!

Question 4 [10 marks] Write a procedure to play the game Rock, Paper, Scissors. To begin the game the user should simply call the function (rps). The user should then be prompted with their score...

CODE MUST BE IN PYTHON. ALSO, PLEASE PROVIDE A HIERARCHY OR STRUCTURE CHART FOR THE CODE. OLA 6: Rock, Paper, Scissors Game Due: Fri Oct 26, 2018 by 11:59 PM-may be turned in until Nov 2 by 11:59 PM...

Need help writing a code in Java: Here is file: /** * This class gives you the computer's move in Rock, Paper, Scissors. */ public class ComputerOpponent { private static boolean TESTING_MODE =...

-Java Programming -Eclipse IDE -Nothing more advanced than chapter on arrays Recommended Group Brainstorm (NO computers during this time) Good programmers think before they begin coding. Part I of...

I'm Taking a C++ programming class and I need a code that could compile this program and run>> Rock Paper Scissors Lizard Spock Your programming assignment is to create the game Rock, Paper,...

Please complete and correct this phyton code so that it performs the task outlined. Then copy and paste the completed code from Python and paste it in your reply as one (easy to understand) document...

This week, you will be writing a Java application program that plays the game of "Paper, Rock, Scissors" with the user. Your program will begin by displaying the title of the game, and asking the...

This is in java. Below is the interface in a file call RPSInterface.java. Please make sure you match the exact output needed. Sorry the write up is quite long. Thank you! /** * An interface that...

Code in c++ NOTE: Put your function prototypes in a header file called play.h, function definitions in an implementation file called play.cpp, and have main only have the main function (be sure to...

Need help on Python Code. When running the program, the ouput is not producing the right result. My code is written down below. PYTHON CODE// import random print("Let's Play The Game OF ROCK! PAPER!...

How has Nature view succeeded in the natural foods channel?

Refer to the data in QS 12-6. Furniture costing $110,000 is sold at its book value in 2009. Acquisitions of furniture total $90,000 cash, on which no depreciation is necessary because it is acquired...

Problem 8-66 Product Mix Decision, Single Constraint Emilys Salon offers three types of haircuts. Each haircut type requires the use of a specially trained stylist. Emilys has a hairstylist total...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...