Add functionality to Excel Macro

IN PROGRESS
Bids
14
Avg Bid (NZD)
$341
Project Budget (NZD)
$250 - $750

Project Description:
Hi,

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.

HEAVENLY

could be shuffled as any of the following

eavenlyh
avenlyhe
venlyhea
enlyheav
nlyheave
lyheaven
yheavenl

I look forward to your bids

Skills required:
Excel, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 750
in 9 days
$ 320
in 7 days
Hire mrbrave
$ 350
in 10 days
$ 500
in 4 days
$ 250
in 6 days
$ 250
in 3 days
$ 300
in 4 days
Hire haingnvt
$ 260
in 5 days
Hire yangli2
$ 250
in 5 days
Hire Z6E7QWas3
$ 500
in 1 days