What is the point of Data-Validation-Ignore Blank?
 

Hi,

I need to make a particular cell a required entry between 1 and 10.
This cell must not be blank. I would have thought that this would be
achieved by
- Setting the Data Validation to Allow="whole number",
data="between", minimum="1", maximum="10"
- Clearing the checkbox "Ignore Blank"

Part 1 works fine, e.g. it gives an error if I enter "11"

However I can go to the cell, delete the contents and it doesn't give
an error. My question therefore is what is the point of the "Ignore
Blank" checkbox if point 2 doesn't prevent the cell from being left
blank?

I've no problem achieving the desired result programmatically, so I'm
not after an alternate solution, I'd just like to know whether this is
a bug or whether this checkbox has a different use.

I've searched for similar posts regarding this checkbox but couldn't
find a definite answer.

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=552169

What is the point of Data-Validation-Ignore Blank?
 

Unchecking ignore blank does not allow you to clear the field with the
Backspace key, but it doesn't stop it being cleared by the Delete key. That
seems like a bug to me, but there may be a reason that I am not aware of.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Vindaloo" wrote in
message ...

Hi,

I need to make a particular cell a required entry between 1 and 10.
This cell must not be blank. I would have thought that this would be
achieved by
- Setting the Data Validation to Allow="whole number",
data="between", minimum="1", maximum="10"
- Clearing the checkbox "Ignore Blank"

Part 1 works fine, e.g. it gives an error if I enter "11"

However I can go to the cell, delete the contents and it doesn't give
an error. My question therefore is what is the point of the "Ignore
Blank" checkbox if point 2 doesn't prevent the cell from being left
blank?

I've no problem achieving the desired result programmatically, so I'm
not after an alternate solution, I'd just like to know whether this is
a bug or whether this checkbox has a different use.

I've searched for similar posts regarding this checkbox but couldn't
find a definite answer.

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile:
http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=552169

What is the point of Data-Validation-Ignore Blank?
 

Thanks for your reply, I'd put my money on it being a bug too.

Regards,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=552169