ControlFormat.ListIndex property (Excel)

Returns or sets the index number of the currently selected item in a list box or combo box. Read/write Long.

Syntax

expression.ListIndex

expression A variable that represents a ControlFormat object.

Remarks

You cannot use this property with multiselect list boxes.

Example

This example removes the selected item from a list box. If Shapes(2) doesn't represent a list box, this example fails.

Set lbcf = Worksheets(1).Shapes(2).ControlFormat 
lbcf.RemoveItem lbcf.ListIndex

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.