new line at sheet textbox
 

ekmektext = txt1.Text & chr(10) & txt2.Text & chr(10) _
& txt3.Text & chr(10) & txt4.Text & chr(10) & txt5.Text

--
Regards,
Tom Ogilvy


GUS wrote in message
...
I am using the following code in order to add text (from userform's
textboxes) to a textbox in a sheet.
How can i create a new line inside the textbox in order to put every
(userform.textbox.value) in a new line inside the sheet textbox?.


ekmektext = txt1.Text & chr(10) & txt2.Text & chr(10) _
& txt3.Text & chr(10) & txt4.Text & chr(10) & txt5.Text



Worksheets("xxxxxxxxx").OLEObjects("textbox1").Obj ect.Value = ekmektext