Norman,
The way I have the worksheet setup is like this...if Yes than a tex
string appears in the next cell to "enter a value". The user enters
value which in turn clears the if...then conditional I had in the cell
If the user clears the selection to start over, I've then lost th
conditional to call the text string "enter a value." I would like th
user to be able to clear choices, and each time keep the conditional
to enter a value. I hope this is a little clearer

--
msals2
-----------------------------------------------------------------------
msals22's Profile: http://www.excelforum.com/member.php...fo&userid=3090
View this thread: http://www.excelforum.com/showthread.php?threadid=54903