It works, are you using the list under allow as

=MyList

where MyList is the name of the list?

works fine for me


Regards,

Peo Sjoblom

"bevpike" wrote:

I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

Attila