Random word generator

Gary Drumm

Active Member
Joined
Feb 22, 2005
Messages
462
Has anyone seen an Excel program that will generate words based on letters entered. For example, if I had 10 cells in a row, and each cell contained a letter (duplicates are okay), what words could be derived from arranging those letters in random sequences.

It would need the ability to accept any letter of the alphabet, A thru Z

E A L R C T S S U C
___ ___ ___ ___ ___ ___ ___ ___ ___ ___

How many words could it generate, and what are the words?
I assume it would have to reference a spelling dictionary.

It could be used as a spelling learning game, etc.

No rush, just curious if anyone has seen something like this.

Gary
 
There are some non-words in the column A, can that be avioded?

Gary

When I ran it, I got 47 words, and a lot of them were non words.
For example, "ns" in your post is not a word.

I used all caps, because it seemed to want to change the i to an L?
Or perhaps it capitolized the i automatically, and it looks like an L?

Anyway, it wasn't working very well until I used all caps, then it listed 47 words (or something close to that), and again, several were not complete words at all.

I posted the code in This workbook?

I'll experiment with it a little bit to see if I can figure it out.

Thanks,
Gary
 
Upvote 0

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Hi Gary

I posted the code in This workbook?

the module "This workbook" should have the code for workbook's events (which is not the case)

Insert a module (if it's the first it will have the name Module1) and paste the code there.

There are some non-words in the column A, can that be avioded?

Unfortunately no. As I referred already in a post in this thread I'm using Microsoft's Check Spelling tool to validate the words.

Microsoft accepts some abbreviations as valid words, like "ns" which is the abbreviation of nanosecond.

If this is really a problem to you, you can only solve it by using another Spell Checker. one that allows you to choose if you want to include abbreviations or not. You'd have to find one (google) and call it from vba.

Kind regards
PGC
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top