Excel TexTwisT

Download Excel File


This program was written by me.

To make a short story long: one of the reasons I put the google search box on this site is because it also gives me a report on what people search for (after not finding it here.) One of the things not found here was "Text Twist", which I didn't know what that was. So I looked to see what that was and thought, "I could program that!"

The game is to take a 6 letter word (letters scrambled), and try to find all possible 3, 4, 5 and 6 letter words using those letters. The play goes just in the textbox on screen -- "enter" uncovers the word (if it's there) and clears the textbox for the next attempt.

With regard to the programming: I've written other Excel modules to do unexpected things with words, so I had a good long word list at hand. I dug that up, scrambled the 6 letter words, and use the built-in spell checker to generate the words for each game. That takes roughly 30 seconds to generate a set on my machine.

This version was built in roughly 2-3 hours. There are things I am not completely satisfied about. First, it takes too long to generate the sub-words. Second, to simplify things I left out all words with repeating letters. Third, since it relies on spellcheck to generate words, it sometimes includes some pretty dubious choices.

All of those, plus ranking of difficulty, could be fixed by storing the sub-words along with the clue. But that would take a lot of memory, so what the heck, I'm leaving it as is.


Have comments about this program? Leave them below!


Previous Comments:

-12345a': 12345a
12345a: -12345a'
jhon: hi there can i get this code without display the word, i need the code that i enter the word then the program find all possible 3,4,5,6,7,8 and 9 letter words
pawpaw: nice!!!
1: -1'
-1': 1
john: button for mixing the letters up
Howly Von Ashtar: WIN!!!
1: -1'
-1': 1
viay: sdsa
chinnybeer: not bad, would like source code for similar in C. Any ideas where i can find?
secret: cool i like it
may Ann: how to play this game and how to compute
dan: terrific
-_-funqixtha_26: i love this game......... plssss.... set more gamessssssssss
Ajay Dwivedi: I won and have some thing to share.....I pressed control+a [Select All] and I saw all the results before pressing an option - I give up. All the words were already appearing there. The text colors changing from white to red that is all.
palak: nice game
Satish: When have u programmed this? It doesnt have new words ...! ny..gud program!
jhen: source code please?
jhay: how create game from excel
Ian: It's too difficult
_';cArLa_@: I Like your Game......,,he.he.he
Rhenzo: How can i do it?
Wicked: Not bad...i want to find where the list of words are
paulcaspe: you can change the words. try to figure out where they are hidden...they're written in one single column....:-)
erkan: hello From Turkey, can we change this game in Turkish mode
Al E. Baba: It doesn't work for me.
Vince Young: Great game. Hook 'em Horns!!
bry: its not working... it says macros are not working..
al: very nice program and site. i'm taking a course on VB in the fall, so hopefully i'll have a few submissions for here later on.
bob: cool

Excel is a registered trademarkof the Microsoft® Corporation.