unansweredMultiple Items from Drop Down List (Separated by 'Alt+Enter' instead of space)

1 year 4 weeks ago #1782 by TheoDuncan
Hello everyone,
I have followed the tutorial for selecting multiple items from a drop down list here: How to select multiple items from drop down list into a cell in Excel?
...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,

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun