Data validation won't restrict user input - please help

A

A. Young

I use data validation allot to restrict user access. Recently, in a financial
workbook I developed, I used data validation drop-down lists in several
columns on all input pages. Most of them work, but the last one I made allows
both the list and any other input. I have it set up to only allow the list
and give an error message otherwise, but it won't restrict input. I have
tried everything and I can't figure out the problem.

I developed this in 2007 for a 2003 user, but I have loaded it in 2003 and
tried to fix it there and no luck. Any help would be greatly appreciated!
 

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

Data Validation 1
Data Validation using Unique Values 2
Data Validation 2
Multiple Data Validation Checks 3
Restrict Duplicates using Data Validation 4
Data Validation List: Text Size Query 2
Restrict choices in one drop down list by response to another 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top