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

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" wrote:

> 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

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

"akphidelt" wrote:

> 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" wrote:
>
> > 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