dynamic range and data validation
 

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???

dynamic range and data validation
 

Highlight the cells.
Select Data, Validation.
The "Error Alert" tab is where you can insist an entry is only allowed
from the list as an Error, Warning or for Information only.

dynamic range and data validation
 

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

dynamic range and data validation
 

Well, I thought that checking the Ignore Blank option meant: YES IGNORE
BLANKS, which is what i want to do... but as you suggested, I un-checked it
and it is working just fine... thanks!!!

"Debra Dalgleish" wrote:

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