Spellcheck via VBA in excel?

  • Thread starter Thread starter Random
  • Start date Start date
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
 
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
 
Back
Top