Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Data Validation

when you first set this up, there is a blank, and it allows that
blank. but once you've selected another value, and then you go to
choose a third value (from this list that has no blanks in it), but
instead don't choose another value but try to backspace to make a
blank, it won't let you.
hope this helps.
susan



On Jun 6, 1:11*pm, Jarrett wrote:
I have created a list of dates to validate for a drop down menu... no blanks
in the list... yet when I unclick the ignore blank, it still allows the entry
to proceed when blank. Any ideas?
--
Jt