Hi,

I need to extract the range index from active x combo box. For ex. when I
select the first row in combo box, I will get the index 1 and assign this to
a cell. I can do this easily with userform in worksheet. just right clicking
and set the text fields. I try to look for under combo box properties, but
don't find any. Should I write any script ?? Could anyone suggest me ??


Thanks.
dennis