| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to copy / paste in userform multiline text box
I have this material from other documents o/s excel in another word
processor that I want to copy and paste into the multiline text box on the userform. Any hints on how this is done? -- wbnTravis, from Oklahoma |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to copy / paste in userform multiline text box
Assuming you have the text to the windows clipboard:
TextBox1.Paste If you need copy the text also, possibly from a Word document, looking into "Automating Word from VBA" in Google Maybe http://www.dicks-blog.com/archives/2...tomating-word/ Otherwise, depends somewhat on the source of the text. NickHK "wbntravis" wrote in message ... I have this material from other documents o/s excel in another word processor that I want to copy and paste into the multiline text box on the userform. Any hints on how this is done? -- wbnTravis, from Oklahoma |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to copy / paste in userform multiline text box
Thanks Nick on both counts of hitting enter in the multi text box
and the answer on paste. to the text box. I cant wait to try them! I wish you the best : ) -- wbnTravis, from Oklahoma "NickHK" wrote: Assuming you have the text to the windows clipboard: TextBox1.Paste If you need copy the text also, possibly from a Word document, looking into "Automating Word from VBA" in Google Maybe http://www.dicks-blog.com/archives/2...tomating-word/ Otherwise, depends somewhat on the source of the text. NickHK "wbntravis" wrote in message ... I have this material from other documents o/s excel in another word processor that I want to copy and paste into the multiline text box on the userform. Any hints on how this is done? -- wbnTravis, from Oklahoma |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
| Userform Textbox multiline Vs format in worksheet | Excel Programming | |||
| transferring multiline text from userform to worksheet - line break problem | Excel Programming | |||
| UserForm; Textbox; Multiline; NonPrintable Characters | Excel Programming | |||
| Copying multiline textboxes from userform to worksheet cell | Excel Programming | |||
Linear Mode
