VBA function to check if a string has valid spelling

[Edward]

I have a word generator that creates various combinations of letters
but I only want to process words that would pass a spell check. Is
there a VBA function that can operate on a string to check its
spelling? I want this to be totally automated, not the CheckSpelling
method that brings up a dialog on misspelled words. I want to skip
misspelled words, not correct them.

 

[JP]

The Application.CheckSpelling method returns True if the word is found
in Excel's dictionary, False otherwise.

http://msdn.microsoft.com/en-us/library/aa223822(office.11).aspx

Note that you have to use Application.CheckSpelling, the other
variations will bring up the dialog box.

--JP

 

[Edward]

The Application.CheckSpelling method returns True if the word is found
in Excel's dictionary, False otherwise.

http://msdn.microsoft.com/en-us/library/aa223822(office.11).aspx

Note that you have to use Application.CheckSpelling, the other
variations will bring up the dialog box.

--JP



- Show quoted text -

Bingo! Thanks.

 

[JP]

You're welcome!

--JP