I want to try and write a wordsearch program to find all valid words in
a grid. The theory is I could pull out every possible word, land that
in a particular cell, then do a range.CheckSpelling on that range. If
it's good, then I add it to a list, if not I don't.

Also how easy is it to distinguish between UK & US spellings - e.g.
honour not honor for example?
--
Mike News

Mike,

Are you thinking of a grid game like Boggle?

If so, I wrote one that I will send to you privately....

Bernie
MS Excel MVP

"Mike" S wrote in message
...
I want to try and write a wordsearch program to find all valid words in a
grid. The theory is I could pull out every possible word, land that in a
particular cell, then do a range.CheckSpelling on that range. If it's
good, then I add it to a list, if not I don't.

Also how easy is it to distinguish between UK & US spellings - e.g. honour
not honor for example?
--
Mike News

In message
at 19:46:02 on Sun, 13 Sep 2009, Bernie Deitrick
wrote
Mike,

Are you thinking of a grid game like Boggle?

If so, I wrote one that I will send to you privately....

Similar, but instead of jumping all over the place, just looking for
words like in a traditional wordsearch, e.g. horizontally, vertically,
or diagonally.

I should be able to adapt Boggle - it's just the code of how to check
individual words that I need to do. Oh and I'm on Excel 2003 :)

Cheers
--
Mike News

Mike,

Application.CheckSpelling(String) will return TRUE when the spelling is OK.
Alternatively, you could check the strings against your word list for a
match. You should probably start with the longest strings and work to
shorter strings, since, for example, "short" is correctly spelled but the
word to be found may actually be "shorter" .....

HTH,
Bernie
MS Excel MVP


"Mike" S wrote in message
...
In message
at 19:46:02 on Sun, 13 Sep 2009, Bernie Deitrick
wrote
Mike,

Are you thinking of a grid game like Boggle?

If so, I wrote one that I will send to you privately....

Similar, but instead of jumping all over the place, just looking for words
like in a traditional wordsearch, e.g. horizontally, vertically, or
diagonally.

I should be able to adapt Boggle - it's just the code of how to check
individual words that I need to do. Oh and I'm on Excel 2003 :)

Cheers
--
Mike News

In message
at 21:01:40 on Mon, 14 Sep 2009, Bernie Deitrick
wrote
Application.CheckSpelling(String) will return TRUE when the spelling is
OK. Alternatively, you could check the strings against your word list
for a match. You should probably start with the longest strings and
work to shorter strings, since, for example, "short" is correctly
spelled but the word to be found may actually be "shorter" .....

Thank you - that works a treat
--
Mike News