Spell Checking

[Don Wells]

I am running Office 2003 and would prefer a solution to my problem in Excel, but failing that, in Word.

Given a particular arrangement of letters, I want to determine whether or not a spelling error is detected (ideally a boolean function).

Although the following code checks the spelling, I can determine no technique to have the code return a boolean response to the question "Is there a spelling error?".

Code: Select all

    Cells(3,3).CheckSpelling SpellLang:=1033

Any guidance will be greatly appreciated.

[StuartR]

According to the help file in Excel 2010 Application.CheckSpelling(Word, CustomDictionary, IgnoreUppercase) returns a boolean value to show if a given word has a spelling error. Does this work in Excel 2003?

[HansV]

Stuart, it's the same in Excel 2003: see CheckSpelling Method [Excel 2003 VBA Language Reference].

[Don Wells]

Stuart and Hans
    Thank you both.
    Does anyone know of an Excel equivalent to:

Code: Select all

ActiveDocument.Range(Selection.Start, Selection.End).SpellingErrors.Count

[HansV]

Excel is not a word processing application. It has some basic spell checking features, but there is no built-in equivalent to the line you posted. You'd have to split cell contents into words, apply Application.CheckSpelling to each word in turn, and count the number of times it returns False.

[Don Wells]

Got it !
Thank you Hans