Retrieve value from .Shapes.AddFormControl(xlDropDown...
 

Hi,
Have created and filled a combobox using .ControlFormat.AddItem

..ControlFormat.Value seems to return just the index number of the
selected item - how can the actual value from the combobox be picked
up? Thanks.

Retrieve value from .Shapes.AddFormControl(xlDropDown...
 

Got it:

MsgBox
excelshapeobject.ControlFormat.List(excelshapeobje ct.ControlFormat.Value)