If the selection box is data validation, just refer to the cell of the DV.

If it is forms dropdown, right-click the object, select Format Control, and
on the Control tab, set the cell link, that refer to that cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DDONNI" wrote in message
...

Hi Guys, can anyone help me with this i'm sure the solution ain't too
bad.

I'm trying to use a selection box and from that use an if formula to
return a certain value depending on what's selected in the selection
box, the problem is i can't point the if statement to a cel as its a
selection and i don't know how to get it to look at the selection box.
Any ideas?

Donni.





--
DDONNI
------------------------------------------------------------------------
DDONNI's Profile:
http://www.excelforum.com/member.php...o&userid=15443
View this thread: http://www.excelforum.com/showthread...hreadid=274844