Posted to microsoft.public.excel.programming
|
|
Validation from a list
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
|