Forum Discussion
Multiple Selections in a Drop Down List in Excel - separator
Claudia350 You can simply repeat (i.e. copy and paste) the code that starts with Case 15, 16 to the row above Case Else:
Then delete the ", 16" in the first Case statement and "15, " in the second one and select the separator of your liking for each of the columns.
Hi mathetes
Thanks for the reply!
"Is there some compelling reason why this has to be accomplished via a VBA macro? "
No other reason except it is the only way I know how to do it. 🙂 I'm definitely open to doing it any other way that solves this - and learning something along the way!
Ok, so:
My only real problem is that I'd like to have different separators in columns O and P. See how both columns are multiple selection columns (which is intended - this was achieved with a VBA macro) and the entries are separated by a plus sign on both columns (which is not intended):
That part of the VBA macro is here:
Target.Value = Oldvalue & " + " & Newvalue
I'd like to have one separator for column O and one for column P.
Very simplified file attached in case it helps.
Thanks again!
Claudia350 You can simply repeat (i.e. copy and paste) the code that starts with Case 15, 16 to the row above Case Else:
Then delete the ", 16" in the first Case statement and "15, " in the second one and select the separator of your liking for each of the columns.
Claudia350 You're welcome!