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

Creating a Search using a combo box and then creating a report. 4
Duplicate entry in a column/row 14
Data Validation 1
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Data Validation using Unique Values 2
Restrict Duplicates using Data Validation 4
Using Data Validation in a Table 0
Data Validation List: Text Size Query 2

Top