SpellingOptions.SuggestMainOnly Property

  • Article
Excel Developer Reference

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.

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 
  Sub UsingMainDictionary()

' Check the setting of suggesting words only from the main dictionary.
If Application.SpellingOptions.<strong class="bterm">SuggestMainOnly</strong> = 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

See Also