Retrieving Key value from dropdown

[Gummadi]

Hi,

I am using a dropdown in Excel Sheet. I have been able to assign a set of
Key-Value pairs to the dropdown. Like for example the text that will be
displayed in drop down are "text101", "text102", "text103" and the
corresponding key values are 101, 102, 103.

Then i am trying to retrieve the key that is selected by the user. I am able
to successfully retrieve the text that is selected but i am not able to get
the key.
If the user selects the text "text102", i should be able to get 102.

I am using Microsoft.Office.Interop.Excel.DropDown xlDropDown.
Can someone tell me how should i retrieve the key value.

Thanks,
Shail

 

[Patrick Molloy]

are you referring to the ActiveX combobox control? so you have the
ColumnCount set to 2, now also set the boundcolumn to 2

 

[Gummadi]

I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

 

[Patrick Molloy]

suggest you switch to the ActiveX controls.

I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

 

[Gummadi]

Can you please post an example of using that control..

 

[Patrick Molloy]

how to use a combo box? really??

http://cid-b8e56c9a5f311cb7.skydrive.live.com/self.aspx/.Public/Excel Files/Comboboxes/gummadi.xls

 

[Gummadi]

thanks .... but i meant a code sample.
if you could provide the code to the example, that will be great ...

 

[Patrick Molloy]

With Sheet1.ComboBox1
.ColumnCount = 2
.BoundColumn = 2
End With