Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |