|Download Excel File|
This program was written by me.
The game is to guess the secret 5 letter word, or an anagram of the word. All 5 letters are different, and so 'quilt' is a legitimate choice, but 'queen' is not. The game gives you up to 20 guesses.
With regard to the programming: Most of the game play is in excel formulas, not VBA. There's one macro to clean up the sheet and select a new word, and some Worksheet_SelectionChange to let you make notes of which letters are ruled out, but the check for if you've gotten the right answer, etc., is all just formula. The worksheet is protected to prevent you cheating, but not password protected if you want to explore the underlying stuff.
Have comments about this program? Leave them below!
Excel is a registered trademarkof the Microsoft® Corporation.