How do I prevent users from entering a blank value in an Excel sheet?
- by Tola Odejayi
I want to restrict users to entering either just 0 or 1 in an Excel 2007 sheet.
I use the Data Data Validation dialog to do this, but I'm finding that it doesn't stop them from entering blanks.
What I would like is for there to be a prompt when they enter blanks, just like the one that appears when they enter any other non-blank data that is not 0 or 1.
I plan to fill the sheet with 0s before applying the validation, so there should not be a problem with erroneous data.
Also, I'm open to using VBA to fix this problem.