Data validation error message not showing

[raphiel2063]

I've set up a cell with data validation from a list and given it a reference
list from another worksheet (using a name). I've gone into the error alert
tab and set a message but nothing is happening if I type junk in (not in teh
list)... any ideas?

I do have macro's on this..

 

[Simon Lloyd]

xl2003 or xl2007?, do you have any worksheet change event code in place

I've set up a cell with data validation from a list and given it
referenc
list from another worksheet (using a name). I've gone into the erro
aler
tab and set a message but nothing is happening if I type junk in (no
in te
list)... any ideas

I do have macro's on this.

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Tom Hutchins]

In the Data Validation dialog, on the Error Alert tab, make sure the "Show
error alert after invalid data is entered" checkbox has a check in it.

Hope this helps,

Hutch

 

[raphiel2063]

Simon,

I'm using xl2007 but I've got the sheet in 2003 as the users haven't got the
new version. Yeah I've got change event code in place but not for these
particular cells. Also, to let you know, the list is being generated from a
lot of data but there are some blanks at the bottom incase the user adds
items...

Thanks.

xl2003 or xl2007?, do you have any worksheet change event code in place?

I've set up a cell with data validation from a list and given it a
reference
list from another worksheet (using a name). I've gone into the error
alert
tab and set a message but nothing is happening if I type junk in (not
in teh
list)... any ideas?

I do have macro's on this..

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=152383

Microsoft Office Help

.

 

[Simon Lloyd]

For further help with it why not join our forums (shown in the lin
below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

Simon

I'm using xl2007 but I've got the sheet in 2003 as the users haven'
got th
new version. Yeah I've got change event code in place but not for thes
particular cells. Also, to let you know, the list is being generate
from
lot of data but there are some blanks at the bottom incase the use
add
items..

Thanks




Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
Code Cage Forums
(http://www.thecodecage.com/forumz/showthread.php?t=152383

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com