Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 07, 02:44 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 1
Default stop a clicked on cell being left blank

I want to stop a cell in excel being left blank once user has clicked on the
cell.

I have a column that has to have a Y or N response. There is data
validation on the cell sop only Y or N can be entered. Nowever once the user
clicks on this cell i want them to HAVE to enter either the Y or N value. At
the moment if they leave it blank it accepts this as a reponse. I would like
it to force them to enter a Y or N before they can continue!

  #2   Report Post  
Old September 6th 07, 04:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 136
Default stop a clicked on cell being left blank

Clear the check next to "Ignore blank" in data vaiidation dialog

"Nicole Answer" wrote:

I want to stop a cell in excel being left blank once user has clicked on the
cell.

I have a column that has to have a Y or N response. There is data
validation on the cell sop only Y or N can be entered. Nowever once the user
clicks on this cell i want them to HAVE to enter either the Y or N value. At
the moment if they leave it blank it accepts this as a reponse. I would like
it to force them to enter a Y or N before they can continue!

  #3   Report Post  
Old September 6th 07, 05:28 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 1
Default stop a clicked on cell being left blank

I tried this - it still accepts a blank value. I have tried it both with the
ignore blank cell ticked and unticked.

Tried saving, cosing reopening no luck. Tried rebooting no luck - so tried
it at home on a completely different PC last night - still wouldnt work.

Any more ideas.

(i have it set to STOP)

"Tevuna" wrote:

Clear the check next to "Ignore blank" in data vaiidation dialog

"Nicole Answer" wrote:

I want to stop a cell in excel being left blank once user has clicked on the
cell.

I have a column that has to have a Y or N response. There is data
validation on the cell sop only Y or N can be entered. Nowever once the user
clicks on this cell i want them to HAVE to enter either the Y or N value. At
the moment if they leave it blank it accepts this as a reponse. I would like
it to force them to enter a Y or N before they can continue!



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
formula in excel that will highlight a cell that is left blank? Kimo Excel Worksheet Functions 4 July 21st 07 04:16 PM
Getting a chart to stop if the formula resutls in a blank cell markag Excel Worksheet Functions 3 August 2nd 06 03:59 PM
Excel VB-Copy formula down until adjacent cell (left) is blank? Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM
How to stop excel from plotting a "blank" cell with formula as zer tiw Excel Discussion (Misc queries) 5 April 21st 05 08:38 PM
reading blank cell as active - how can I stop it ? Nu-bEE Excel Discussion (Misc queries) 1 March 20th 05 10:45 PM


All times are GMT +1. The time now is 01:24 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017