Hi -

I am created my combobox using activeX control. In the linked cell
properties, I specified the cell.
When I select an option in the combobox I want the linked cell to show the
option number rather than the option itself.
Cell Value
D56 4
D57 8
D58 7


For eg:
Linked cell : $D$53
I left the listfillrange blank but wrote a program in VBA to list the values
in my combobox
Sub Combobox1_enter()
Me.ComboBox1.Clear
Me.ComboBox1.AddItem (Sheets("Input").Range("D56"))
Me.ComboBox1.AddItem (Sheets("Input").Range("D57"))
Me.ComboBox1.AddItem (Sheets("Input").Range("D58"))
End Sub

If in my combobox I picked 8 (D57), I don't want the linked cell to show 8
but rather I want it to show 2 for second option picked in the list. How do I
do this.

Thanks