ErrorCheckingOptions.TextDate Property (Excel)

When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, cells that contain a text date with a two-digit year. False disables error checking for cells containing a text date with a two-digit year. Read/write Boolean.

expression .TextDate

expression A variable that represents an ErrorCheckingOptions object.

In the following example, the AutoCorrect Options button appears for cell A1, which contains a text date with a two-digit year.

Sub CheckTextDate() 
 
 ' Simulate an error by referencing a text date with a two-digit year. 
 Application.ErrorCheckingOptions.TextDate = True 
 Range("A1").Formula = "'April 23, 00" 
 
End Sub 

Show:
© 2014 Microsoft