Example

Use the property to return the Validation object. The following example changes the data validation for cell E5.

Visual Basic for Applications 
Range("e5").Validation _ .Modify xlValidateList, xlValidAlertStop, "=$A$1:$A$10"

Use the method to add data validation to a range and create a new Validation object. The following example adds data validation to cell E5.

Visual Basic for Applications 
With Range("e5").Validation .Add Type:=xlValidateWholeNumber, _ AlertStyle:=xlValidAlertInformation, _ Minimum:="5", Maximum:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from five to ten" End With
Describe Validation object? validation validation object

See also: