VBA Query

[Piplinson]

Hi all

I have some VBA code that allows me to select multiple items in a drop down list and populate the data in a single cell. The code works in multiple columns. I have attached a screenshot. 

What I am trying to do is add a Char(10) 'within cell' line break - so that each selection goes to a new line within the same cell (rather than append). No matter what I try, i can't seem to get it to work. Any ideas what I am missing?

Pip

[#2]

@Piplinson Perhaps this link will help

https://excelchamps.com/vba-new-line/ 

[#3]

@Piplinson

Interesting code, but I couldn't find where the line-feed is being inserted. 

All I found was

"    |    "

but that may be my failing.

One basic check on the worksheet is has your cell alignment been set to

'Wrap Text"?