Data Validation and Dynamic Ranges

[Guest]

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

 

[Bob Phillips]

Check that the Show error alert box on the Error tab is checked.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi,

For more information about Data Validation, please refer to the following URL:
http://www.contextures.com/xlDataVal02.html

Challa Prabhu