drop down cell link to worksheet not working
 

Matt

It's displaying the index of the selected item. You would use that against
your input range using the INDEX worksheet function to return the actual
value to where you want

Alternatively you could use an activeX control )from the control toolbox and
return it's value back to the worksheet using code?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Matt" wrote in message
...
I have a Dialog box with a combo list (Form Control), I have selected an
input range with 5 cells selected from a spreedsheet. The Problem I am
facing
at the moment is when I use the "cell Link" command back to a cell in my
worksheet it does not show the true content ... Eg if I select my second
value (1250) in the combo list, it displays '2' back in my worksheet cell
instead of the true value.. How would I change that sequence to show my
true
values?