Blank values accepted in a list validated field

Nederbrakel

New Member
I have a named range without blanks in it.
I have configured cells in a column to be validated against this list.
If I type in a value that is not in the list and tab out of it, I get the expected error message, but if I leave the cell blank I get no error at all when leaving the cell.
I have "Ignnore blanks" un-ticked, although I have tried both options.
I have also tried using a table column as my named range.
Can anyone tell me what I am doing wrong?
 

Nederbrakel

New Member
Thanks. My understanding now is that the only way to avoid a blank entry is by using VBA. It has made me rethink the requirement. Enforcing this would mean that if someone clicks in the cell, there is no getting out of it without selecting an entry. Although that was my initial requirement, in which case the VBA in the above topic should resolve it, I'm no longer sure it is such a good idea in my scenario. Thanks again for your assistance.
 

Akuini

Well-known Member
Thanks. My understanding now is that the only way to avoid a blank entry is by using VBA. It has made me rethink the requirement. Enforcing this would mean that if someone clicks in the cell, there is no getting out of it without selecting an entry. Although that was my initial requirement, in which case the VBA in the above topic should resolve it, I'm no longer sure it is such a good idea in my scenario. Thanks again for your assistance.

Yes, I think VBA is needed to resolve it.
If your scenario is the user will get warning if he leave the cell empty and then is given a choice to leave it empty or get back to it, I think that's doable by macro.
 

Some videos you may like

This Week's Hot Topics

Top