SpellingOptions Object

  • Article
Excel Developer Reference

Represents the various spell checking options for a worksheet.

Remarks

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.

Example

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.

Visual Basic for Applications 
  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

See Also