------ Register to get rid of these "In Post" ads! ------
Quote:
Originally Posted by Simon Lloyd
Keith, i'm at work and off home to bed in a couple of hours (it's been a long night!) so i wont get chance to look at it for a good few hours but will try and get to it when i get up  |
Thank you. I appreciate it. I have been able to find some more help and am pasting the final code I have. Now I want to edit the code so that I can make the application to all the sheets, instead of applying just to Sheet1 in the following line in the code:
I want to edit the code attached so that I can include more columns in addition to A1 columns of all sheets, not just Sheet1. My Excel template would have several named dynamic lists on one sheet (sheet2 in this example)and those lists would be pulled by many dropdown menus based on those lists in several cells in different worksheets. As an example, I have two lists in colums A and C in Sheet2. I have two dropdown menus in Sheet1 in cell A1 and E15. The code I have so far allows multiple selection only from the range in column A of sheet2 in cell A1 of sheet1; it doesn't allow those functionality for the list in column C of sheet2 in cell E15 of sheet1. Again, as I mentioned, I am struggling to have the multiple selection and add items to the dropdown menu functionality available in any sheet on any cell, not just sheet1. I hope I have defined the problem clearly. Thank you.