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.

Evner: Excel, Software Arkitektur, VB.NET, Visual Basic, Visual Basic for Apps

Se mere: microsoft excel programming, excel programming tutorial, excel programming language, excel programming pdf, ms excel programming, programming in excel 2016, excel programming course, excel programming examples, excel programming average rate, excel programming sql, quickbooks import excel name type, excel content type extjs, excel programming database, excel programming consulting service, excel data type data process cnet 2008, contract excel programming, excel programming using visual basic, project excel programming, advanced excel programming, excel programming hourly rates

Om arbejdsgiveren:
( 0 bedømmelser ) taxila, Pakistan

Projekt ID: #18074972

Tildelt til:


Hi, I am the new member on freelancer.com site. I already made similar games using Excel VBA which are more complicated (etc. Association multiplayer game) , so my estimated time for this game is 1-2 day. I have Flere

$15 USD in 10 dage
(1 bedømmelse)

5 freelancere byder i gennemsnit $15 på dette job

$14 USD på 1 dag
(75 bedømmelser)

We have done lot of excel programs for our prestigious clients... Message me to discuss more and do the needful with your requirements.... Regards,

$15 USD på 1 dag
(1 bedømmelse)

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Flere

$15 USD in 3 dage
(0 bedømmelser)

This looks like a school assignment and I am FULLY CONFIDENT of completing this assignment exactly as stated. If you wish, I can also use the GPL licensed (free to use) card images when dealing cards to each player whe Flere

$15 USD på 1 dag
(0 bedømmelser)