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

  • Thread starter Thread starter groupie
  • Start date Start date
G

groupie

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.
 
Got it:

MsgBox
excelshapeobject.ControlFormat.List(excelshapeobject.ControlFormat.Value)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still Having Trouble with Combo Box 8
Cases within Cases 7
More Problems with CBO's 5
Retrieving Key value from dropdown 7
Name Check Box in code 4
ActiveCell.Top question 1
Values in multiselect listbox 2
How to set Optionbox value from code? 2

Back
Top