Combo Box data

[Steve Pike]

Hi all,

I am attempting to extract data from a combo box in
excel. I have tried doing so by linking the combo box to
a cell in its properties - but this only produces the
number of the selection from the box. How can I get it to
produce the actual text into the linked cell - rather than
the line number from the combo box?

Any help would be greatly appreciated!!!

Regards,

Steve Pike

 

[papou]

Hello Steve
Use the Combobox control from the Controls Tool Box instead it will retrieve
the actual value from the list (see ListFillRange and LinkedCell
properties).
If you still wish to use the Combobox from the Forms Tool Bar, you will have
to use a VLOOKUP Or INDEX and MATCH functions to retrieve the actual value
selected in your combobox.
HTH
Cordially
Pascal