Skip to content

Latest commit

 

History

History
45 lines (26 loc) · 1.11 KB

Excel.Application.ErrorCheckingOptions.md

File metadata and controls

45 lines (26 loc) · 1.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.ErrorCheckingOptions property (Excel)
vbaxl10.chm133280
vbaxl10.chm133280
Excel.Application.ErrorCheckingOptions
3821c6fd-e6c2-70cc-f546-70fdac6a6161
04/04/2019
medium

Application.ErrorCheckingOptions property (Excel)

Returns an ErrorCheckingOptions object, which represents the error checking options for an application.

Syntax

expression.ErrorCheckingOptions

expression A variable that represents an Application object.

Example

In this example, the TextDate property is used in conjunction with the ErrorCheckingOptions property. When the user selects a cell containing a two-digit year in the date, the AutoCorrect Options button appears.

Sub CheckTextDate() 
 
 ' Enable Microsoft Excel to identify dates written as text. 
 Application.ErrorCheckingOptions.TextDate = True 
 
 Range("A1").Formula = "'April 23, 00" 
 
End Sub

[!includeSupport and feedback]