Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation from a list
Patrick:
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_close 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 . . .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a Data validation list to select another validation l | New Users to Excel | |||
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel |