ListDataValidation Property

A Boolean value that is True if data validation is enabled in a list. Read/write Boolean.

expression.ListDataValidation

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

Data validation for a list can also be turned on or off by in the user interface by selecting or clearing the List data validation error check box on the Error Checking tab of the Options dialog box.

Example

    Sub PrintListValidationOnOrOff()
    Debug.Print Application.ErrorCheckingOptions.ListDataValidation
End Sub