Are you using a named list on a worksheet?

Make sure that Data|Validation|Settings tab|Ignore blank is not checked.

If you included blanks at the end of the list to make it easier to update, maybe
using a dynamic range would be better.

See Debra Dalgleish's site for more information:
http://contextures.com/xlNames01.html#Dynamic


clara wrote:

Hi all,

I use a data validation to limit input, but other data can also be typed in
the cell, what can I do to not allow user to input other data?

Clara
--
thank you so much for your help

--

Dave Peterson