LinkBack URL
About LinkBacks
Hi All,
Is there a way to limit the max value of a cell without creating a list?
Ex. The user has to enter a value in say Cell A1. The max allowed value is 500. If the user exceeds that amount the value has to return to 500.
Thanks
Hi All,
Is there a way to limit the max value of a cell without creating a list?
Ex. The user has to enter a value in say Cell A1. The max allowed value is 500. If the user exceeds that amount the value has to return to 500.
Thanks
You can use data validation to do that.
Is there a minimum value? Does it have to be a whole number?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,
It has no minimum value and it is whole numbers only.
How would you use data validation to limit the value? I looked through it but clearly missed something
Try this...
Select cell A1
Goto the Data tab>Data Validation
Allow: Whole number
Data: less than or equal to
Maximum: 500
You can use a custom error message if desired. Click the Error Alert tab and fill in the info.
OK out when finished.
Try it out. Enter some random numbers in A1 and see what happens.
Ok so I had a look at it again.
The data validation only gives a warning if the value entered is out of the range specified giving me 2 options:
1. Retry - which allows the user to enter another value.
2. Cancel - returning the cell to the previous value.
I require that if a user enters a value above 500, the value in the cell is returned to 500 (cell started off blank)
That's not possible without using an event macro.
I was hoping that would not be the solution.
Thank you very much for the help.
You're welcome.
Good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks