Biff

It will not "prevent" a value over 2500. If a value greater than 2500
is entered then the message pops up. Because it's a "warning" and not
an "error" the message adds the question "Continue?" and there are 3
options - Yes, No, Cancel.

If you choose Yes then the value entered is accepted. I believe that
fits what the OP requires.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=489619