Creating games using Microsoft Excel: Tic Tac Toe

Tic Tac Toe game creeated with Microsoft Excel

Tic Tac Toe

Many people that use Excel may be surprised to learn that lurking in the back of Excel is a fairly decent programming language called Visual Basic for Applications or VBA and this is available for all users (or at least PC users) to play with. If you want to see it open Excel hold down Alt and press F11. A new window will open that looks quite different to usual Excel windows.

The language is based on Visual Basic but has been modified to make use of the features in Microsoft Office. It is also built into Word and other Office applications and it is there to enable users to create powerful tools within Office that can do a series of tasks or other tasks than cannot be done thie the usual builtin tools.

While it is not designed for creating free standing applications or creating games, to some that has become a challenge. Some quite sophisticated games have been created.

When I started to learn VBA I wrote a couple of games. One of them was a Tic Tac Toe or Noughts and Crosses as it is better known in Australia.

It runs in Excel 2003 and 2007 and probably 2010, but I have not tested it with that. Macros have to be enabled to run the game. See my Excel page to see how to do this. Feel free to modify and distribute it.

Download TicTacToe.xls (75kb)

There are a couple of good sites that have other Excel games, DzikoSoft Excel Games Library is one and Excel games is another, but a quick search will find others.

Advertisements

Posted on May 2, 2012, in Excel, Word & VBA and tagged , , , , , . Bookmark the permalink. Comments Off on Creating games using Microsoft Excel: Tic Tac Toe.

Comments are closed.

%d bloggers like this: