CheckSpelling function

[Mike]

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?

 

[Bernie Deitrick]

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]

In message <[email protected]>
at 19:46:02 on Sun, 13 Sep 2009, Bernie Deitrick

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

 

[Bernie Deitrick]

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]

In message <[email protected]>
at 21:01:40 on Mon, 14 Sep 2009, Bernie Deitrick

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