ListDataValidation Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | ErrorCheckingOptions Object