how to copy / paste in userform multiline text box

[Guest]

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?

 

[NickHK]

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/2004/08/13/automating-word/

Otherwise, depends somewhat on the source of the text.

NickHK

 

[Guest]

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 : )