Paragraph Mark appears in textbox

Hi Guys,
I seem to have a paragraph mark appearing in a userforms textbox which is set to retrieve data from one worksheet and insert into another. When I insert the retrieved data via the user form with the textboxes into the worksheet the data is disjointed and skips rows, if I remove the paragraph mark from the end of the data in the textbox it inputs into the worksheet fine but it is a niggle I have to remove. I think it has something to do with the format but I just cant find the solution. I would appreciate some help. Thanks in advance

Hi xlnitwit,

I have attached the invoice with the userform. It is user form ClientInvShpInputForm that retrieves the data from another workbook. I can't attach that as it has client details in it.

Just looked up what a linefeed is and yes. When the data inputs into the worksheet 'salesinvoice' the data drops to the next row. It also misses out a line of text. In a couple of cases it drops several rows.

Hmmn further developments it appears to only happen to clients which have other references in their address Such as 'U.099', ' Unit E17', 'SU255 Level 1'. Could excel be trying to interpret these and attempt to do something with them which ends up being a linefeed?

Each client is on a separate row and each line of the address is in a separate column.

Mark Dynes

Paragraph Mark appears in textbox

It happens when MultiLine property of textbox set to False.

Hi Jindon, thanks for this. This did remove the paragraph mark but for some reason the input data still removes the first line of the address as it did before. Any thoughts?

Check "wrap text" in the cell?

I thought that it might have just suppressed it but I can't find any line feed character in the data!! It happens on some and not on others and the cell formats all match throughout the worksheet. I have tried to copy and then paste just the values into a new worksheet and I still get the same issue??

Yup thanks, checked that and the text is not wrapped in any cells.

If you don't have enough height for multi lines in a cell, it only displays one line...

Ok fixed it, thanks for your help. The worksheet I was taking data from had multi lines in the cell but the sheet I was sending the data to did not. Another glitch 'bytes' the dust