Validation type | Arguments |
|
xlValidateCustom | Formula1 is required; Formula2 is ignored. Formula1 must contain an expression that evaluates to True when data entry is valid and False when data entry is invalid. |
xlInputOnly | AlertStyle, Formula1, and Formula2 are not used. |
xlValidateList | Formula1 is required; Formula2 is ignored. Formula1 must contain either a comma-delimited list of values or a worksheet reference to the list. |
xlValidateWholeNumber, xlValidateDate, xlValidateDecimal, xlValidateTextLength, or xlValidateTime | Formula1 or Formula2, or both, must be specified. |