Drop downs in excel 2007

Hi,

I am not sure whether this question has already been asked in the forum.

I have a drop down which I am populating from my code in Visual Studio. I have a "display value" which I am providing as the item in the drop down. I also have a "store value" which is again a string and which I need to be stored along with the display value in the drop down.

I thought of converting it to integer and storing it in the listIndex property, but that is throwing COM exception.

Is their any other place where I can store the "store value" so that I will be able to directly retrieve the store value whenever an item is selected in the drop down?

Thanks,
Dhruvan.