You have chosen to sponsor your bid up to a maximum amount of .
I have a macro that is used to create a word game and I would like to add some more fuctionality to it.
At the moment I enter the clue words and answers, into the work sheet manually, what I would like to do is automate this by having the macro autofill the question and answers. from Excel's builtin thesaurus. To do this successfully the macro will need to
1).Randomly select a clue word from the thesaurus headwords.and enter it in the spreadsheet
2) Randomly select an answer from a clue words list of synonyms and enter it in the spreadsheet
3) Limit answers to LESS than thirteen characters
4) Exclude phrases. For example if "Verbose" was the clue word the synonym "Long winded" would be excluded as answer
SHUFFLE ANSWERS CHARACTER ORDER
The other functionality I would like added is the option to shuffle an answer's characters automatically by randomly breaking an answer in two and shuffling the pieces for example.
could be shuffled as any of the following
I look forward to your bids