If there's a blank cell in the range you'll be able to type any value in
the cell with data validation.
If that's the problem, remove the blank cells from the range, or on the
Settings tab in the Data Validation dialog box, remove the check mark
from Ignore blank.
GSB wrote:
Hi, I have list range where I put data validation to prevent users from
entering wrong options. Then I put a drop-down list that is populated from a
dynamic range of a list of valid options in another worksheet (same workbook)
and set up the data validation to show an error message if an user tries to
enter a non-valid option.
The thing is... it is not working. The drop down list works fine, but I
still can enter any value and recieve no message.
What am I not considering here???
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html