Data Validation and Dynamic Ranges
 

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

Data Validation and Dynamic Ranges
 

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)



"GSB" wrote in message
...
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???

Data Validation and Dynamic Ranges
 

Hi,

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

Challa Prabhu

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