Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ListDataValidation Property

ListDataValidation Property [Excel 2003 VBA Language Reference]

Office 2003

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


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


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.


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

© 2015 Microsoft