Excel drop down lists with multiple entries

Question

hi,

I need a code that lets me make multiple entries in a drop down list. I found this code: https://www.contextures.com/excel-data-validation-multiple.html - which seems to work. However, I have multiple columns with different drop down lists in my sheet. I don't know how to code, so I can't see how to change the code so that it works for all drop down lists in my sheet.

Thanks in advance for your help.

Answer 1

Hi @Anne Ryder ,
Based on your description, I suggest you post this issue to Excel for developer forum:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Drop-downs, VBA and most of Contextures is passé.
Just describe your given task in English and
maybe share your database in a linked file.
You might have to learn a lot of new stuff.