A couple of Fridays ago, in the What’s in Your Desk Drawer comments, Doug Glancy mentioned that he had created a concentration game in Excel.
One of my first Excel VBA programming fun projects was to write one for my daughter and I to play. It had multiple decks, 3 user modes and “animated” cards (the pairs moved across the screen to a pile when correctly selected). Somewhat fun to play, and a great learning experience.
Download the Sample File
Doug sent me a copy of the file, so you can see the game for yourself: Excel Concentration Game
When the file opens, you can enable the macros, so the game will run. There’s one worksheet, with a button that you click to start the game.
The Game
The game opens, with a deck of cards, turned face down. You select two cards and try to match the pictures.
The game records the number of clicks, time used, and the match count. I am very bad at this game!
There are game options, including number of players, and type of card.
How It Works
Doug’s concentration game is built on a UserForm. In the sample file you can see all the code that makes it operate. It took me a couple of minutes to find the sets of cards – one for mammals and one for birds. They’re to the right of the visible area on the UserForm.
Other Excel Games
Do you know of any other free Excel games out there?
____________________
It’s an Excel version of Memory that I used to play as a kid. Very fun. Although my son is only 2, I’ll save this game for him to play in a few years (right now he just likes to pound on the keyboard).
Thanks for sharing, Doug.
Here’s some
http://www.dailydoseofexcel.com/?cat=6
Jason, you should start playing now — if you wait a couple of years, he’ll be able to beat you! But keyboard pounding is fun too.
Dick, thanks for the link!
Debra, thanks for putting this up! I remember trying to figure out where to put the “decks” and deciding just to hide them on the form. Don’t know what I’d do now.
[…] a Jawbreak game, adapted for Excel by Andy Pope, who is a very creative guy. Like Doug Glancy’s Concentration game, this game is based on a UserForm, with a button on the worksheet to start the […]
Going to have a look at this with my computer class. Show them that you can make games in Excel. Thanks CyberSam
Is the vba code that comes up when the file is opened the only code used to create the game? If not is there a way to view the entire code?
hey i was wondering what a simple code of the concentration game would look like. i tried a few different codes and they arent working