data validation

  • Thread starter Thread starter bruno1
  • Start date Start date
B

bruno1

i am having a problem where validation seems to disappear after i add data to
a list. i created a list of data and defined a name. i included extra rows
in my column list cause i know i need to add data regularly. i added data to
my list, and as soon as i go to the dropdown, it allows me to enter anything.
Also, if anyone can tell me how to make the data "autofill" - typing in
partially, and it fills in a value from the list.

thanks
 
This looks like it will help me. Thanks! Still baffeled by my initial issue
though. It seems that when the "Ignore blank" box is checked off it creates
problems. looks like another quirky excel thing.

Ron said:
I think you could benefit from visiting Debra Dalgleish's website.
Start here:

http://www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP
i am having a problem where validation seems to disappear after i add data to
a list. i created a list of data and defined a name. i included extra rows
Click to expand...
[quoted text clipped - 4 lines]
thanks
Click to expand...
Click to expand...
 
Back
Top