VBA Query

Question

Hi all&nbsp;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.&nbsp;&nbsp;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?&nbsp;Pip&nbsp;&nbsp;

riny_van_eekelen · Answer

Piplinson&nbsp;Perhaps this link will helphttps://excelchamps.com/vba-new-line/&nbsp;

peterbartholomew1 · Answer

PiplinsonInteresting code, but I couldn't find where the line-feed is being inserted.&nbsp;All I found was"&nbsp; &nbsp; |&nbsp; &nbsp; "but that may be my failing.&nbsp;One basic check on the worksheet is has your cell alignment been set to'Wrap Text"?&nbsp;

Forum Discussion

VBA Query

2 Replies