Rey,

No, data validation lists must be in a range of cells.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Rey" wrote in message
...
Is there a way to get the list for validation from a text
file instead of a range within the sheet?

Please help. I want to set the dropdown to get the list
from a text file.