Data Validation and Dynamic Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

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