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

[Vindaloo]

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

1. Setting the Data Validation to Allow="whole number", data="between", minimum="1", maximum="10"
2. 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

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Vindaloo]

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

Regards,
Vindaloo