Take a look at Debra Dalgleish's notes:
http://contextures.com/xlDataVal05.html

Kevin wrote:

I have looked every where to find out how to validate cells, with your list
in a different work book. I know how to do it in the same workbook or same
sheet but is there any way you can do it in a different wook book?

Thanks,

Kevin

--

Dave Peterson