Programming Excel with VBA and .NET

SpellingOptions Members

The SpellingOptions object has the following members:

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

Figure 7-5. Displaying error-checking options

The SpellingOptions object provides a set of properties that determine how Excel handles spellchecking. All of the Spelling members are read/write properties that enable or disable specific options. The following code displays a list of the current spell-checking settings in Excel:

Sub ShowSpellCheckSettings(  )
    With Application.SpellingOptions
        Debug.Print .DictLang
        Debug.Print .IgnoreCaps
        Debug.Print .IgnoreMixedDigits
        Debug.Print .SuggestMainOnly
        Debug.Print .UserDict
    End With
End Sub

These properties correspond to the settings on the Spelling tab of the Options dialog box (Figure 7-6). To see that dialog, choose Tools → Options → Spelling.

Tip

Language-specific settings in Figure 7-6 are disabled because my selected language is English (U.S.). You must install those language versions of Excel to use those settings.

Figure 7-6. Displaying the spellchecking options