SpellingOptions.SuggestMainOnly Property

Syntax

expression.SuggestMainOnly

expression A variable that represents a SpellingOptions object.

Example

In this example, Microsoft Excel checks the spell checking options for suggesting words only from the main dictionary and reports the status to the user.

Visual Basic for Applications

Visual Basic for Applications
`Sub UsingMainDictionary() ' Check the setting of suggesting words only from the main dictionary. If Application.SpellingOptions.SuggestMainOnly = True Then MsgBox "Spell checking option suggestions will only come from the main dictionary." Else MsgBox "Spell checking option suggestions are not limited to the main dictionary." End If End Sub`

Sub UsingMainDictionary() ' Check the setting of suggesting words only from the main dictionary. If Application.SpellingOptions.SuggestMainOnly = True Then MsgBox "Spell checking option suggestions will only come from the main dictionary." Else MsgBox "Spell checking option suggestions are not limited to the main dictionary." End If End Sub

suggest suggest main only suggestmain suggestmainonly suggestmainonly property

SpellingOptions.SuggestMainOnly Property

When set to True, instructs Microsoft Excel to suggest words from only the main dictionary, for using the spelling checker. False removes the limits of suggesting words from only the main dictionary, for using the spelling checker. Read/write Boolean.

See also: