Excel Blackjack

	Download Zipped File

Description

This program was written by Carlos Rondão.

The good news for us VBA geeks is that this game's modules are open for inspection. The bad news for those of us who are not literate in Portugese is that this may not lead to much understanding. If you want to learn how to use cards in your own Excel games endeavors, you should see his tutorial at Cyberbolsa (look under Conteudos:downloads). With the help of Babelfish, I think I have got some understanding.

Basically, the program makes use of Excel VBA's ability to manipulate pictures in order to define and manipulate the cards. Carlos inserted the 52 pictures and named them in order as C 1, C 2, ..., C 52. Using Modulo 13 arithmetic you can assign the proper value and suit to each card in the VBA code. The VBA can then treat the deck as a 52 element array, and pull up the correct picture by reference. Pretty simple, really, aside from the painful part of setting up the pictures initially.

Comments

This site's comment form has been retired -- shown below is the archived comment history from the previous site.

• Me: Good game
• Honest Bob: Hung: step 1 - learn programming. Samantha: don't pass other people's programs as yours. GOD: go back to playing halo you stupid lamer.
• atul: hello
• Hung: how do u create a game like this? i like to know the step by step?
• Samantha: Can you give me the password because I'm painfully trying to do this for my computer programming class and I cannot do VBA
• rnj: radioflyer, where do I send the e-mail. Your version sounds great.
• radioflyer54: I have created a new version of this game - it includes the ability to split the hand, insurance, dealer takes a card on a soft seventeen, double down, surrender. All written in good clear English and well commented. I used this games ideas and cards (the cards look great!) - plus there is a new number of cards - 4 decks! so you can select to shuffle each time or let the dealer run through the deck for those that like to count cards. Send me an e-mail to get your copy! radioflyer54
• R: Where is this tutorial, can't find it in Cyberbolsa.
• vrom: <i>very much</i>
• hax: <> awesome >
• Dealer: Would be a much better game if you had the split and insurance offers.
• WTF NOOB!!!: yea it was ok, good work
• STFU NOOB!!!: i thought it was cool. end
• adam: doesnt play
• Matt F: Nice one mate
• Kirk: Thanks for the downloads
• test: I try to put my cards on the dealers pile but it does not cause him to lose