Syntax

expression.InCellDropdown

expression A variable that represents a Validation object.

Remarks

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

Use theargument of the Addor Modifymethod of the Validationobject to specify the range that contains valid data.

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.

Visual Basic for Applications 
With Range("e5").Validation .Add xlValidateList, xlValidAlertStop, xlBetween, "=$A$1:$A$10" .InCellDropdown = True End With
display data validation drop down list in cell dropdown In Cell Dropdown Property incell InCellDropdown incelldropdown property show list data validation cell

See also:

Minimum