Re: Validation>lists - Named Ranges Force Correct Input
Quote from AAE
I don't know why it makes a difference but it does . . .
In the validation dialogue, on the Error Alert tab, make sure you have it set to show an error alert after invalid data is entered.
I just tested it to make sure. After I deselected it, I was able to enter any value, but after re-enabling it to display the alert I was not.
UGH! I tried what you said and it doesn't work. I have the following
Data Validation: Allow List: Source =Admin_Type (my named range), Ignore Blank and In-Cell Dropdown are checked. "Apply these changes..." is not checked
Input message tab: nothing checked
Error Alert tab: "Show error alert" is checked. I have tried all three options on the pull down and title and error message for all three options to no avail.
What is wrong? Did I not name my range correctly maybe?