Spell Checking Custom Properties
 

does this recent post by Rob Bovey help?

The procedure below shows how you can use Excel's spelling feature to
determine if a list of words is located in the dictionary. Enter some words
and non-words into cells A1:A10 on Sheet1 and then run the procedure to see
how it works. A message box will be displayed for each word that the
spelling feature can't locate. This doesn't mean that it isn't a real word,
it just might be misspelled.

Sub LookForWordsInSpellingDictionary()
Dim bFound As Boolean
Dim rngCell As Range
Dim rngTable As Range
Set rngTable = Sheet1.Range("A1:A10")
For Each rngCell In rngTable
bFound = Application.CheckSpelling( _
Word:=rngCell.Value, IgnoreUppercase:=False)
If Not bFound Then
MsgBox rngCell.Value & " was not located."
End If
Next rngCell
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses
--
Regards,
Tom Ogilvy

"Colin Sheppard" wrote in message
om...
Hello,

Does anyone have some suggestions on how to use VBA to Spell Check
(and Grammar Check) Custom Properties of a entity/file?

For example, I may wish to have a form that contains text boxes which
contain text destined for a Customer Property. I would like to spell
check that text box BEFORE adding it to the custom property.

(It would also be nice that it could be incorporated in such a way
that I do no need to run a seperate instance of Microsoft Word to
check it with.)

Thanks for your suggestions.

Regards,

Colin.