Drop Down Lists and Error Alerts

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

Guest

I have created a drop down list and want to put in an error alert, so that
people cannot enter text into the fields (and can therefore only use the data
in the drop down boxes).

I have gone to the error alert tab in data validation and ticked the show
error alert after invalid data is entered and the selected stop from the drop
down box (and entered a short message).

However, when I have tested the fields it is still allowing me to enter text
and no warning message is coming up.

Any ideas on what else I might need to do to make it work.

Thanks.
 
What data validation criteria have you applied, and what are you entering?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
The criteria that I have applied is:

Allow: List
Ignore blank: Ticked
In-cell dropdown: Ticked
Source: In there I have =ProductList

This refers to a named range that I have on another sheet, which includes
the fields to go into the drop down box.
 
I have just replicated your situation and I get the message as expected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Try unchecking the "ignore blank" box.
The criteria that I have applied is:

Allow: List
Ignore blank: Ticked
In-cell dropdown: Ticked
Source: In there I have =ProductList

This refers to a named range that I have on another sheet, which includes
the fields to go into the drop down box.
Click to expand...
 
Back
Top