Validation from a list

[German]

I have 3 entries to be filled out in a worksheet, entry for cell A, comes from a list from another file, I am getting the list with a collection, how do I put the list or the collection on cell A as the only inputs available, after A is selected, with the event worksheet_change I will bring another list of entries from same file to cell B, entries for cell C are similar to B, after is filled row 1, I wan to change the focus to A2, it has to be A,B, and C in that order, How do I pass the collection to the cell A to begin

Thanks

 

[Patrick Molloy]

Copy your collection to another worksheet and range name
it something like "ListA"
The in your main sheet, you can set th eDataValidation
for A as List and set the source to =ListA

Ypur change event can do something similar for B. Ie
populate a new range in the other sheet and call it
ListB. The set th edata validation for cell B as List
with the source set to =ListB

HTH
Patrick Molloy
Micrsoft Excel MVP

-----Original Message-----
I have 3 entries to be filled out in a worksheet, entry

for cell A, comes from a list from another file, I am
getting the list with a collection, how do I put the list
or the collection on cell A as the only inputs available,
after A is selected, with the event worksheet_change I
will bring another list of entries from same file to cell
B, entries for cell C are similar to B, after is filled
row 1, I wan to change the focus to A2, it has to be A,B,
and C in that order, How do I pass the collection to the
cell A to begin?

 

[Dave Peterson]

Debra Dalgliesh has some nice instructions for using datavalidation and
dependent lists at:

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

And this may be useful, too:

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

It shows a technique (& restrictions, too!) for having the list in another
workbook.