Data Validation and Dynamic Ranges

G

GSB

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

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)
 
Top