How do I prevent users from entering a blank value in an Excel sheet?
Posted
by
Tola Odejayi
on Super User
See other posts from Super User
or by Tola Odejayi
Published on 2010-12-23T21:19:58Z
Indexed on
2010/12/23
21:56 UTC
Read the original article
Hit count: 169
excel-2007
|data-validation
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.
© Super User or respective owner