| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link a textbox on a sheet to a cell?! | Excel Discussion (Misc queries) | |||
| How can i import data from a cell in another sheet, into a textbox | Excel Worksheet Functions | |||
| Textbox changes position on a copied excel-sheet | Excel Discussion (Misc queries) | |||
| Possibility of counting line in textbox?? | Excel Programming | |||
| Accessing a textbox on a sheet.... | Excel Programming | |||
Linear Mode
