Jim Borland wrote:Okay, so "locking" a user in the cell until they fix their mistake is not a good idea
Here's another thought. What if I could restore the previous value when the user changes it to something other than a positive number. In other words, there is a valid number in the cell now but user changes it to text, so the alert pops up and the cell's value automatically reverts to the previous valid number.
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |