Validation.Modify procedure builder

Validation.Modify (Excel)

Modifies data validation for a range.

The Modify method requires different arguments, depending on the validation type, as shown in the following table.

Modify (Type, AlertStyle, Operator, Formula1, Formula2)

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

Arguments

Optional arguments

The following arguments are optional

Type (XlDVType) - An XlDVType value that represents the validation type.


Possible Values are

xlValidateCustom Data is validated using an arbitrary formula.
xlValidateDate Date values.
xlValidateDecimal Numeric values.
xlValidateInputOnly Validate only when user changes the value.
xlValidateList Value must be present in a specified list.
xlValidateTextLength Length of text.
xlValidateTime Time values.
xlValidateWholeNumber Whole numeric values.

AlertStyle (XlDVAlertStyle) - An XlDVAlertStyle value that represents the validation alert style.

Possible Values are xlValidAlertInformation - Information icon, xlValidAlertStop - Stop icon, xlValidAlertWarning - Warning icon.

Operator (XlFormatConditionOperator) - An XlFormatConditionOperator value that represents the data validation operator.


Possible Values are

xlBetween Between. Can be used only if two formulas are provided.
xlEqual Equal.
xlGreater Greater than.
xlGreaterEqual Greater than or equal to.
xlLess Less than.
xlLessEqual Less than or equal to.
xlNotBetween Not between. Can be used only if two formulas are provided.
xlNotEqual Not equal.

Formula1 - The first part of the data validation equation

Formula2 (XlFormatConditionOperator) - The second part of the data validation equation when Operator is xlBetween or xlNotBetween; otherwise, this argument is ignored.


Possible Values are

xlBetween Between. Can be used only if two formulas are provided.
xlEqual Equal.
xlGreater Greater than.
xlGreaterEqual Greater than or equal to.
xlLess Less than.
xlLessEqual Less than or equal to.
xlNotBetween Not between. Can be used only if two formulas are provided.
xlNotEqual Not equal.