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 . . .. |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com