SpellingOptions Object [Excel 2003 VBA Language Reference]

Application SpellingOptions

Represents the various spell checking options for a worksheet.

Using the SpellingOptions object

Use the SpellingOptions property of the Application object to return a SpellingOptions object.

Once a SpellingOptions object is returned, you can use its following properties to set or return various spell checking options.

• ArabicModes
• DictLang
• GermanPostReform
• HebrewModes
• IgnoreCaps
• IgnoreFileNames
• IgnoreMixedDigits
• KoreanCombineAux
• KoreanProcessCompound
• KoreanUseAutoChangeList
• SuggestMainOnly
• UserDict

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 mispelled 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 Property | DictLang Property | GermanPostReform Property | HebrewModes Property | IgnoreCaps Property | IgnoreFileNames Property | IgnoreMixedDigits Property | KoreanCombineAux Property | KoreanProcessCompound Property | KoreanUseAutoChangeList Property | SuggestMainOnly Property | UserDict Property

Parent Objects | Application Object

Child Objects