ActiveX Combobox and LinkedCell

[aqualibra]

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

 

[akphidelt]

Haven't ever used the ActiveX combobox but you can do the exact same thing
using the Forms Combobox... and that linked cell will just give you the
number that you want.

 

[aqualibra]

I know that form combobox does it, but I have certain conditions that I have
to use for the combobox and therefore need to use activeX