Hello everyone,
I have followed the tutorial for selecting multiple items from a drop down list here: https://www.extendoffice.com/documents/excel/5234-excel-select-multiple-items-from-drop-down-list.html
...following the 'without repeats' version of the code and have got it working, however, ideally for my purposes I would need to separate the items with a new row (like I had pressed 'Alt+Enter' in the cell), instead of a space.
Does anyone have any ideas on how to achieve this?
It would be very much appreciated.
Kind regards,
Theo
I have followed the tutorial for selecting multiple items from a drop down list here: https://www.extendoffice.com/documents/excel/5234-excel-select-multiple-items-from-drop-down-list.html
...following the 'without repeats' version of the code and have got it working, however, ideally for my purposes I would need to separate the items with a new row (like I had pressed 'Alt+Enter' in the cell), instead of a space.
Does anyone have any ideas on how to achieve this?
It would be very much appreciated.
Kind regards,
Theo