list box

[Tom G]

I'm trying to use a list box. When any one of the entries is selected, the
cell link returns the number of the item that's selected in the list box
(the first item in the list is 1).

I want the value in the cell link to be the value from the input range.

Any suggestions?

Thanks,

tom

 

[Harald Staff]

Hi Tom

You need either an Index formula in the neighbor cell, or a macro, to do
that.

HTH. Best wishes Harald