Possible Combinations of given letters

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

How can I create a form that can do the following:

Form has five text fields, where user can enter any five
words (one word in each text box)

Form has another button with caption "Generate all
possible combinations".

Once the user hits the above button, I want the form to
spit out all possible combinations of all the letters in
the given five words.

Any thoughts or suggestions on how to approach this.

Please help.
 
-----Original Message-----
How can I create a form that can do the following:

Form has five text fields, where user can enter any five
words (one word in each text box)

Form has another button with caption "Generate all
possible combinations".

Once the user hits the above button, I want the form to
spit out all possible combinations of all the letters in
the given five words.

Any thoughts or suggestions on how to approach this.

Please help.
.
Click to expand...
Hi Mario,
just a thought, you could use the split function to create
five arrays. then work your way though these arrays
automating a manual approach...

Luck
Jonathan
 
How can I create a form that can do the following:

Form has five text fields, where user can enter any five
words (one word in each text box)

Form has another button with caption "Generate all
possible combinations".

Once the user hits the above button, I want the form to
spit out all possible combinations of all the letters in
the given five words.

Any thoughts or suggestions on how to approach this.

Please help.
Click to expand...

If they even if they don't put in words like
antidisestablishmentarianism this will end up being a VERY long
list...! <g>

I'd suggest writing some VBA code to parse the letters into an array,
and then using a brute-force looping to write out all the
combinations. Note that if the five words have 50 letters amongst
them, this will be 50! = 3.0414093201713378043612608166065e+64
possible combinations, not including blanks or correcting for
repeating letters. Lay in a good stock of paper!
 
Back
Top