excel programming

Create a VBA sub program that creates a game for multiple players and finally declares the winner. The detailed procedures to create the game are given below:

• Create a spreadsheet and place the buttons as shown below in the picture.

• When the button “play” is clicked, the program should ask for the number of players and the number of cards.

• After getting the inputs, generate two random number, one for the card number and the other for the suit.

• Associate the first randomly generated numbers to the cards. For example, if you design a random number between 2 and 14, the numbers 2 through 10 represent the same value. The number 11 represents J, 12 – Q, 13 – K and 14 – A respectively.

• Associate the second set of randomly generated numbers to the suits. For example, if you design a random number between 1 and 4, the number 1 represents SPADES, 2 – DIAMONDS, 3 – HEARTS and 4 – CLUBS.

• Run a for loop to generate as many cards as you want and place them in the spreadsheet and run a for loop to calculate the points won by each player (For example, if a player has the card A-SPADE, then A translates to 14 points and SPADE translates to 1 point as coded in the random generator).

• Declare the player as “WINNER” as the player with the most points.

• Create a second sub program to clear the cells. Assign this sub program to the button “Clear”.

The following pictures show the results for 5 players and 9 cards.

❖ The points in the blue cells for each player are the sum of points earned by players from the number on the card and the type of card.

Excel Software Architecture VB.NET Visual Basic Visual Basic for Apps

Project ID: #18074972

About the project