Excel Concentration Game

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.

Conc01

The Game

The game opens, with a deck of cards, turned face down. You select two cards and try to match the pictures.

Conc02

The game records the number of clicks, time used, and the match count. I am very bad at this game!

Conc03

There are game options, including number of players, and type of card.

Conc04

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.

Conc05

Other Excel Games

  • John Walkenbach has an Excel Keno game on his website, and there are a few games in his PUPv7 add-in.
  • Chip Pearson has a page of Excel games, including a couple that are similar to Minesweeper.

Any other free Excel games out there?

____________________

You may also like...

8 Responses

  1. Jason Morin says:

    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.

  2. 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!

  3. Doug Glancy says:

    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.

  4. Contextures Blog » Excel Jawbreak Game says:

    […] 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 […]

  5. CyberSam says:

    Going to have a look at this with my computer class. Show them that you can make games in Excel. Thanks CyberSam

  6. Paul says:

    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?

  7. John Smith says:

    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

Leave a Reply

Your email address will not be published. Required fields are marked *