0 out of 1 rated this helpful - Rate this topic

Validation Object (Excel)

Published: July 16, 2012

Represents data validation for a worksheet range.

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

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

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

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 

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.