Nick Hodge
12/19/2006 12:44:00 AM
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
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk
"Matt" <Matt@discussions.microsoft.com> wrote in message
news:9292AC58-66A7-41DF-8854-7C3F1478644D@microsoft.com...
>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?