Multi-line text box inserts a carriage return symbol in cell, can I stop/remove it?

Good day all,

I have a userform with textboxes, one of which has Enterkeybehaviour set to True and Multiline also set to true.
when the enter key is used in the userform it inserts a carriage return symbol into the cell for each return.

Is there any way to stop this occurring or remove the symbol from the cell? I've hopefully added a picture to show whats happening after completion of the userform.

New Picture.jpg

Hi loveridge01,

I believe what you say, but I was unable to duplicate the problem in either Excel 2003 or 32 bit Excel 2010. See the attached file Cell "A21".

Lewis

Only thing I can work out is that it is a font issue, as when I open your example the problem is there in A21..
The only font I have that the problem wasn't showing in the cell is the 'Cambria' font.

I was still unable to duplicate the problem with the Cambria, Calibri or Arial font. Perhaps if you upload a sample file, the problem may be seen by others.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic