ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spellcheck via VBA in excel? (https://www.excelbanter.com/excel-programming/276053-spellcheck-via-vba-excel.html)

Random

Spellcheck via VBA in excel?
 
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

Keith Willshaw

Spellcheck via VBA in excel?
 

"Random" <Random@nwhere wrote in message
...
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


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




All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com