Transfer data from userform textbox to sheet

[rhombus4]

On a userform when I transfer a standard textbox to a cell it transfers ok (Range("C3").Value = TextBox1)

However if I want the text box to be wrapped, i.e. change Multiline to True and EnterKeyBehaviour to True it transfers the data differently with speechmarks

Any ideas??

 

[VBABEGINER]

This is what i get..

[FONT=&quot]A multiline TextBox allows absolute line breaks and adjusts its quantity of lines to accommodate the amount of text it holds. If needed, a multiline control can have vertical scroll bars.[/FONT]
[FONT=&quot]A single-line TextBox doesn't allow absolute line breaks and doesn't use vertical scroll bars.[/FONT]
[FONT=&quot]For controls that support the MultiLine property as well as the WordWrap property, WordWrap is ignored when MultiLine is False.[/FONT]
[FONT=&quot]Single-line controls ignore the value of the WordWrap property.[/FONT]
[FONT=&quot]If you change MultiLine to False in a multiline TextBox, all the characters in theTextBox will be combined into one line, including non-printing characters (such as carriage returns and new-lines).[/FONT]
[FONT=&quot]The EnterKeyBehavior and MultiLine properties are closely related. The EnterKeyBehavior values of True and False only apply if MultiLine is True. IfMultiLine is False, pressing ENTER always moves the focus to the next control in the tab order regardless of the value of EnterKeyBehavior.[/FONT]

 

[rhombus4]

So is it possible to do