Spellcheck via VBA in excel?

R

Random

Does anyone know if it is possible to access Office spellcheck through
VBA to check the text in a cell and ensure that the text is in fact a
word?

Not really business related yet... but some of my workers tend to use
creative spelling on a regular basis.

Any help would be greatly appreciated.


Random
 
K

Keith Willshaw

Random said:
Does anyone know if it is possible to access Office spellcheck through
VBA to check the text in a cell and ensure that the text is in fact a
word?

Not really business related yet... but some of my workers tend to use
creative spelling on a regular basis.

Any help would be greatly appreciated.


Random
Click to expand...

The CheckSpelling method can be called for any range
from a single cell to the whole sheet

Dim IsOK as Boolean

IsOK = ActiveSheet.Range("A1").CheckSpelling

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 Spellcheck 1
word spellchecking in excel 1
Spellchecking a Protected Document 5
Spellchecking against a hidden Word object 0
Can't Spellcheck individual form fields in a protected form 7
Spellcheck only certain form fields in a protected doc 2
Spellcheck only certain form fields in a protected Word doc 0
How to invoke spellchecker in VBA to check a string? 1

Top