Hi there,
I am currently using a VBA code on numerous tabs of my spread sheet (that I sourced from online), which allows the Excel user to select multiple options from a drop-down list (in a specific column/s), so that each value they select is then separated by a comma. I am a teacher and we needed to enable users to select multiple student names from a data validation list, to receive particular awards. I now want to know how to adjust the code so that instead of making this applicable to any number of columns with these drop-down lists, I can select a single cell and its drop-down list. The reason for this need is because the other cells in the column only require one option to be selected, but this specific cell requires FOUR options. I have pasted the current code I use below, which applies to the whole column D (4). Could anyone please suggest how I change it to only apply to cell D9? Thank you!
Bookmarks