다음을 통해 공유


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.

Syntax

.TextDate

A variable that represents an ErrorCheckingOptions object.

Example

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 

참고 항목

개념

ErrorCheckingOptions Object Members

ErrorCheckingOptions Object