AJP Excel Information AJP Excel Information

Code Cracker

 
 
   
 
This is a variation on the Mastermind game. See if you can crack the 4 colour code.

Drag & drop the coloured pegs on to the board.
If you have already placed a peg and want to change your mind simply drag & drop another coloured peg on it.
You can do this as much as you like until you are ready to check your code against the hidden one.
Each black score peg means you have correctly match the colour and position in the code.
The white score peg means you have match the colour but not the location.
Obviously the position of the scoring pegs has no relation to the position of your code, that would be too easy!

Due to the use of raised events in the code this will only work with xl2000 and greater.
I must mention Andrew Engwirda who's own version of the Mastermind game inspired, or should that be distracted, me into putting this game together. Thanks Andrew!
Code cracker workbook
I have now added a xl97 version which gets around the use of raised events.
Code cracker workbook XL97 
   


Excel 97 version

Created August 2004
Last updated 5th August 2014 


Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page


Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope