CheckSpelling function

  • Thread starter Thread starter Mike
  • Start date Start date
M

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?
 
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
 
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....
Click to expand...
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,

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
 
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" .....
Click to expand...
Thank you - that works a treat
 
Back
Top