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!