Question: Can someone help me write the code for this in vba. If you could include screenshot of the test run, that'd be greatly appreciated Introduction

Can someone help me write the code for this in vba. If you could include screenshot of the test run, that'd be greatly appreciated
Introduction to Engineering Computation ENGS 116 Homework #5 Due: 3/14/15 Vrite a VBA program that will create a simplified blackjack game. The requirements for e code are outlined belovw In the simplified game the player and the dealer will only be able to have a maximum of 3 cards delt. . .All cards will be randomly assigned values between 2 -11 .The player will be shown their first 2 cards and the dealers 1 card on the excel spreadsheet The program will then ask the player if they would like to hit or stay If they chose hit another card will be dealt and then it's the dealers turn Have the total of all the cards dealt to the player appear on the spreadsheet fthey chose stay no card is dealt and it is the dealers turn The dealer's decision will be made by the program based on the following criteria - o If the sum of the first 2 cards 21 a message box will appear saying Dealer BlackJack Game Over o If the sum of the first 2 cards > 15 the dealer will stay o If the sum of the first 2 cards15 the dealer will take another card Have the total of all the cards dealt to the dealer appear on the spreadsheet Have a message box appear to let the player know if they win or lose the hand Create a button that says DEAL to start the game Get the program to run for up to 5 cards dealt to each the player and the dealer Introduction to Engineering Computation ENGS 116 Homework #5 Due: 3/14/15 Vrite a VBA program that will create a simplified blackjack game. The requirements for e code are outlined belovw In the simplified game the player and the dealer will only be able to have a maximum of 3 cards delt. . .All cards will be randomly assigned values between 2 -11 .The player will be shown their first 2 cards and the dealers 1 card on the excel spreadsheet The program will then ask the player if they would like to hit or stay If they chose hit another card will be dealt and then it's the dealers turn Have the total of all the cards dealt to the player appear on the spreadsheet fthey chose stay no card is dealt and it is the dealers turn The dealer's decision will be made by the program based on the following criteria - o If the sum of the first 2 cards 21 a message box will appear saying Dealer BlackJack Game Over o If the sum of the first 2 cards > 15 the dealer will stay o If the sum of the first 2 cards15 the dealer will take another card Have the total of all the cards dealt to the dealer appear on the spreadsheet Have a message box appear to let the player know if they win or lose the hand Create a button that says DEAL to start the game Get the program to run for up to 5 cards dealt to each the player and the dealer
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
