Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vindaloo
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Vindaloo
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should let you graph every n-th data point in a column warrenrob50 Charts and Charting in Excel 3 March 3rd 06 08:42 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"