SpellingOptions.IgnoreMixedDigits Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

False instructs Microsoft Excel to check for mixed digits, True instructs Excel to ignore mixed digits when checking spelling. Read/write Boolean.

expression .IgnoreMixedDigits

expression A variable that represents a SpellingOptions object.

In this example, Microsoft Excel determines what the setting is for the checking of spelling for mixed digits and notifies the user.

Sub SpellingOptionsCheck() 
 
 If Application.SpellingOptions.IgnoreMixedDigits = True Then 
 MsgBox "Spelling options for checking mixed digits is disabled." 
 Else 
 MsgBox "Spelling options for checking mixed digits is enabled." 
 End If 
 
End Sub
Show: