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

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?

Thanks
.

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.


German wrote:

I was trying to avoid an intermediate worksheet, Is this
the only way?, if is that the case I will create an empty
tmpworksheet on open event and erase it on before_save
event. How do I setup the focus A1,B1,C1,A2,B2,C2.....etc

Thanks

-----Original Message-----
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?

Thanks
.

.


--

Dave Peterson