Class SpellingOptions (Excel VBA)

The class SpellingOptions represents the various spell checking options for a worksheet.

Class Application gives access to class SpellingOptions.

Member in collection

Item

To use a SpellingOptions class variable it first needs to be instantiated, for example

Dim sos as SpellingOptions
Set sos = Application.SpellingOptions

SpellingOptions class variables can be set using the Application.SpellingOptions procedure.

Properties

ArabicModes returns or sets the mode for the Arabic spelling checker.

ArabicStrictAlefHamza returns or sets whether the spelling checker uses rules regarding Arabic words beginning with an alef hamza.

ArabicStrictFinalYaa returns or sets whether the spelling checker uses rules regarding Arabic words ending with the letter yaa.

ArabicStrictTaaMarboota returns or sets whether the spelling checker uses rules to flag Arabic words ending with haa instead of taa marboota.

BrazilReform returns or sets the mode for checking the spelling of Brazilian Portuguese.

DictLang selects the dictionary language used when Microsoft Excel performs spelling checks.

GermanPostReform true to check the spelling of words by using the German post-reform rules. False cancels this feature.

HebrewModes returns or sets the mode for the Hebrew spelling checker.

IgnoreCaps false instructs Microsoft Excel to check for uppercase words; True instructs Excel to ignore words in uppercase when using the spelling checker.

IgnoreFileNames false instructs Microsoft Excel to check for Internet and file addresses; True instructs Excel to ignore Internet and file addresses when using the spell checker.

IgnoreMixedDigits false instructs Microsoft Excel to check for mixed digits; True instructs Excel to ignore mixed digits when checking spelling.

KoreanCombineAux when set to True, Microsoft Excel combines Korean auxiliary verbs and adjectives when spelling is checked.

KoreanProcessCompound when set to True, this enables Microsoft Excel to process Korean compound nouns when using the spelling checker.

KoreanUseAutoChangeList when set to True, this enables Microsoft Excel to use the auto-change list for Korean words when using the spelling checker.

PortugalReform returns or sets the mode for checking the spelling of European Portuguese.

RussianStrictE returns or sets whether the spelling checker uses rules regarding Russian words containing the character ë.

SpanishModes returns or sets the mode for checking the spelling of Spanish.

SuggestMainOnly when set to True, instructs Microsoft Excel to suggest words from only the main dictionary when using the spelling checker. False removes the limits of suggesting words from only the main dictionary when using the spelling checker.

UserDict instructs Microsoft Excel to create a custom dictionary to which new words can be added when performing spelling checks on a worksheet.