Modify Method (Validation Object) Example

This example changes data validation for cell E5.

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