Here is my question:

Let's say cell A1 is the cell to be changed and I want to restrict the
value of it to 1, 2, 3, 4, 7, 10, 100, or 500. A1 must be chosen from
one of those values, how can I set up the constraints for this
situation?


Thank you.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=376929