InCellDropdown Property

Applies To

Validation object.

Description

True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.

Remarks

This property is ignored if the validation type isn't xlValidateList.

Use the Minimum argument of the Add or Modify method of the Validation object to specify the range that contains valid data.

See Also

Add method (Validation object), ErrorMessage property, ErrorTitle property, IgnoreBlank property, InputMessage property, InputTitle property.

Example

This example adds data validation to cell E5. The range A1:A10 contains the acceptable values for the cell and the cell displays a drop-down list that contains those values.

With Range("E5").Validation
    .Add xlValidateList, xlValidAlertStop, xlBetween, "=$A$1:$A$10"
    .InCellDropdown = True
End With