Data Validation Error Message

Dear Community,

Good Evening........

Attached is a spreadsheet. On the sheet entitled "scenario" Column B3:151 is a drop down list with a choice between the word "Removed" or leaving the cell "Blank".

I would like to stop the user entering anything other than "Removed" or "Blank", and should the user try, I would like a msg to pop up.....

Thanks for your time.

In the data validation setups, turn on the STOP setting under the Error Alerts tab.

Hi JB. Thanks for your response.

I have tried > Data tab > Data Validation button >Error Alert > ticking show error alert after invalid data is entered > ok

But I can still enter other stuff.

Am I missing somthing obvious here!! should I be reallly embarrased!!

Thanks for your time.

What did you put for the "STYLE" option in that same window? You want STOP.

Hi JB,

Originally Posted by JBeaucaire

What did you put for the "STYLE" option in that same window? You want STOP.

Thanks for your response, still not working...... Spreadsheet attached, but here are my settings....

Settings > allow List > Source =status > Error Alert Styl > Stop > OK
however, i can still write stuff other that the drop down list in the cells

Any further help appreciated.

Thanks

Why have you put
Source:=
=status
in as your named list?

If you change this to
Source:=
REMOVED

Then all is okay

Hi there, I have put source =status as that is the list name.

When I tyed Source = Removed I got the error msg "A named range you specified cannot be found"

anymore ideas? this is driving me to drink!!

Sheet TUS is password protected that is why I missed your named list, It didn't highlight when I called it.

However with Sheet "Scenario Tool"

Select B3

Data Validation > Allow:=

Please Login or Register  to view this content.

Source:=

Please Login or Register  to view this content.

Check the box:= Apply these changes to all..........

Seems to work for me, see the attachment.

Hi mate, sorry for taking so long to respond, two children!!

I think I see where the problem arose, my named list contained two cells - one blank and one with the word removed.......

I have now removed the blank cell, (in fact, i got rid of the list all together) and put source= removed and it works a treat.

so does that mean that one can't have a blank in a named list and have a data validation warning?

Hope all well with you, thanks alot for your help. Snowing here!

If you want to have a blank cell as an option, then say your basing your list on what is in A1:A2 A1 being the word removed in a2 you need to have ="" so when you include that in a dropdown, you will have the word removed or a blank cell showing. If you try and put anything other than ="" in the blank option you'll get the error alert

Hi ScottyLad & Mahju.

Thanks very much for your help and taking the time to respond... really good stuff.

Have a good one.