Data Validation List: source from other Worksheet?

[jungix]

I'm trying to do a data validation list, and in excel I can't specify the source from another Worksheet. Is there a way to do it in Excel, or if no in VBA?

[lucas]

If you use a range you can access it for data validation from any sheet

[jungix]

??
I don't understand.

When I specify in the source: =Sheet2!$A$1:Sheet2!$A$7, I get the error message: "You may not use references to other worksheets or workbooks for Data Validation criteria"

[mdmackillop]

If you use a range you can access it for data validation from any sheet

If you use a range NAME you can access it for data validation from any sheet

[lucas]

You can also use indirect to use a list from a different sheet. Try using this for your data validation:
=INDIRECT("Sheet2!A1:A10")