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