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.

Start button for Excel concentration game
Start button for Excel concentration game

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

Do you know of any other free Excel games out there?
____________________

9 thoughts on “Excel Concentration Game”

  1. 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. 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.

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

  4. 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?

  5. 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 to Maggie A Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.