IgnoreMixedDigits Property

Microsoft Excel Visual Basic

IgnoreMixedDigits Property

       

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   Required. An expression that returns one of the objects in the Applies To list.

Example

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