Bob, if your list is on another sheet you have to name the range, have a
look here for details

http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bob" wrote in message
...
I don't have experience on Excel, but I need to create a list Box. I have
placed Named Lists which will be the choices in the Data Validation cells
on
a different worksheet on the same work book. When I use the Validation to
populate the data on the drop down box on another worksheet, I get a
message
"You may not use reference to other worksheets or workbook for data
validation" What does this means?
All I wont is having the data source of the drop down list on a different
worksheet. .Is this possible please ?

--
Bob