How to limit user's input with data validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Hi there,

I have a named list called Fruits and have four itmes: blank line, apple,
orange,grape. I do a datavalidation on a cell let's call A1 with this named
list.
But other data can also typed in A1 that is not what I want it.

Clara
 
Why do you have the blank line in that range named Fruits? Can't you just name
the range with the 3 non-blank items?

Or make sure that option is unchecked.


Hi there,

I have a named list called Fruits and have four itmes: blank line, apple,
orange,grape. I do a datavalidation on a cell let's call A1 with this named
list.
But other data can also typed in A1 that is not what I want it.

Clara
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

validated, stop all calculations on bad data 1
data validation 4
How to make a data validated field refresh 6
execute assigned data validation in vba? 11
Date Entry through input prompt 9
Data validation dependent on value in another cell. 2
A data validation question 1
Using Data>Validation cell formatting to drive OnEntry/Intersect m 1

Back
Top