ComboBox Activex Linked Cell displaying numbers

Hi all,

can anyone tell me how to change what linked cell display for an activex combobox? I want it to behave like a form combobox: if i chose the first word on the list, the linked cell displays 1. If i chose the third thing on the list, the linked cell display 3.

With activex the linked cell displays the value(or text) which is currently selected. I dont want that :/

thanks in advance!

You'd tell it to put it's index in the cell in the Change() sub

yup. Thanks

Please Login or Register  to view this content.