data validation will allow you to have the error message you want. Jus
use the error alert tab.

As far as using a list from another sheet i have tried to do this an
you cant (unless you write something yourself) So i put my lis
somewhere in the middle of teh sheet that way if something is moved
dont lose any of the list. Just make sure you click on the box at th
bottom that applies changes to all other cells with same setting

--
Message posted from http://www.ExcelForum.com