SpellingOptions object (Excel)
Represents the various spell checking options for a worksheet.
Remarks
Use the SpellingOptions property of the Application object to return a SpellingOptions object.
After a SpellingOptions object is returned, you can use the following properties to set or return various spell checking options:
- ArabicModes
- DictLang
- GermanPostReform
- HebrewModes
- IgnoreCaps
- IgnoreFileNames
- IgnoreMixedDigits
- KoreanCombineAux
- KoreanProcessCompound
- KoreanUseAutoChangeList
- SuggestMainOnly
- UserDict
Example
The following example uses the IgnoreCaps property to disable spell checking for words that have all capitalized letters. In this example, "Testt", but not "TESTT", is identified by the spell checker.
Sub IgnoreAllCAPS()
' Place misspelled versions of the same word in all caps and mixed case.
Range("A1").Formula = "Testt"
Range("A2").Formula = "TESTT"
With Application.SpellingOptions
.SuggestMainOnly = True
.IgnoreCaps = True
End With
' Run a spell check.
Cells.CheckSpelling
End Sub
Properties
- ArabicModes
- ArabicStrictAlefHamza
- ArabicStrictFinalYaa
- ArabicStrictTaaMarboota
- BrazilReform
- DictLang
- GermanPostReform
- HebrewModes
- IgnoreCaps
- IgnoreFileNames
- IgnoreMixedDigits
- KoreanCombineAux
- KoreanProcessCompound
- KoreanUseAutoChangeList
- PortugalReform
- RussianStrictE
- SpanishModes
- SuggestMainOnly
- UserDict
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.