Disable validation error messages

You can allow users to only add values from a list using data validation

Yes, that's where I'm at now. But if they DON'T type in a correct value, it spits out an error message. I want that error message not to pop up. I want the worksheet to just wait on the cell until they DO type something in that works.

I tried the code but it didn't work. I must be pasting it in the wrong place. I'm pretty new to VBA. I tried pasting it into one specific worksheet's object, but it didn't take effect on that worksheet. Then I tried inserting a new module and pasting it there, still no luck. I DO want this to take effect for the entire workbook as well, so not sure if something needs to be changed. Can you help with where to paste this?

But, I doubt the wisdom of presenting the user with a situation where "it doesn't work and it won't tell me why."

And the validation is "whole numbers" and the users know it's impossible to record anything but whole numbers, but if they slip and work fast I don't want the results to show anything but whole numbers. So for accuracy of the end result I put a validation on the cells. The only thing the error box said is that I restricted use of this number anyway, so it provides no direction. That's why I'd like to disable it. Thanks!

Or this would be a good way to tackle this, but I don't know how to do it.

Maybe just have code to round up the numbers entered to the nearest whole number, and I'll leave the validation so that it will error only if they enter negative numbers. Would it be able to round up before the validation error hit??? Not sure what order they go in. That way it would eliminate the need for them to type in another number, it would just round up and move on. So if they are not looking at the screen and just inputting info it won't even hesitate. They most likely will NEVER screw up the fact that they can't type negatives in there, the only screw ups will be decimals, that I can see of.

I'm guessing the only way to round up a number entered where the entry cell and destination cell are the same is using VBA?

Got it, it works great thanks! Ignore my other post below, this works exactly as I'd hoped!

Or this would be a good way to tackle this, but I don't know how to do it.

Maybe just have code to round up the numbers entered to the nearest whole number, and I'll leave the validation so that it will error only if they enter negative numbers. Would it be able to round up before the validation error hit??? Not sure what order they go in. That way it would eliminate the need for them to type in another number, it would just round up and move on. So if they are not looking at the screen and just inputting info it won't even hesitate. They most likely will NEVER screw up the fact that they can't type negatives in there, the only screw ups will be decimals, that I can see of.

I'm guessing the only way to round up a number entered where the entry cell and destination cell are the same is using VBA?

One more thing I didn't notice earlier. The worksheet that this will be used on is password protected. I tried using the code below

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

but I couldn't seem to place them in the right spot to get it to work. I've tried for awhile, but can't get it working. Can this code be modified to incorporate a password protected sheet? Thanks much! Here's the original code.

Please Login or Register  to view this content.

works great thanks mikerickson!