Problems with Combobox in Userform

  • Thread starter Thread starter Marcus Pedersén
  • Start date Start date
M

Marcus Pedersén

Hello!
I need some help as I can not get around my problem.
If I use a Combobox on the sheet with 4 rows the linked cell shows the
number of the row selected but if I do the same in a userform with a
combobox the linked cell writes out the text instead. I can´t figure out how
to make the linked cell to show the number of the selected row instead. (I
use the number to select witch equation to make in a later step...) Please
help me on this one.......

Many thanks in advance!

Marcus
 
If you use the DropDown from the Forms toolbar, you get that behavior--the index
into the list, not the value itself.

But if you use a combobox from the control toolbox toolbar, you'll see you get
the value of the combobox.

You could use a helper cell that contains a formula:

=match(yourlinkedcell,yourlist,0)
like:
=MATCH($B$1,$A$1:$A$10,0)

to get the number.
 
Back
Top