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

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

"Gummadi" wrote in message
...
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

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

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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

suggest you switch to the ActiveX controls.

"Gummadi" wrote in message
...
I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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

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

"Patrick Molloy" wrote:

suggest you switch to the ActiveX controls.

"Gummadi" wrote in message
...
I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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

how to use a combo box? really??

http://cid-b8e56c9a5f311cb7.skydrive...es/gummadi.xls



"Gummadi" wrote in message
...
Can you please post an example of using that control..

"Patrick Molloy" wrote:

suggest you switch to the ActiveX controls.

"Gummadi" wrote in message
...
I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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

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

"Patrick Molloy" wrote:

how to use a combo box? really??

http://cid-b8e56c9a5f311cb7.skydrive...es/gummadi.xls



"Gummadi" wrote in message
...
Can you please post an example of using that control..

"Patrick Molloy" wrote:

suggest you switch to the ActiveX controls.

"Gummadi" wrote in message
...
I am using Microsoft.Office.Interop.Excel.DropDown and i do not see the
columnCount and boundColumn properties.

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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

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


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

"Patrick Molloy" wrote:

how to use a combo box? really??

http://cid-b8e56c9a5f311cb7.skydrive...es/gummadi.xls



"Gummadi" wrote in message
...
Can you please post an example of using that control..

"Patrick Molloy" wrote:

suggest you switch to the ActiveX controls.

"Gummadi" wrote in message
...
I am using Microsoft.Office.Interop.Excel.DropDown and i do not see
the
columnCount and boundColumn properties.

"Patrick Molloy" wrote:

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

"Gummadi" wrote in message
...
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