Creating games using 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)
Posted on May 2, 2012, in Excel, Word & VBA and tagged excel, games, naughts & crosses, noughts and crosses, Tic Tac Toe, vba. Bookmark the permalink. Comments Off on Creating games using Microsoft Excel: Tic Tac Toe.