moving to CLIPBOARD

J

jason

Is it possible that when a userform is initialised, that the contents
of one of its textbox's is already pasted into the clipboard - so that
the user could go to an e-mail and simply press Ctl + V and the text
will appear.

Jason
 
C

Chip Pearson

Jason,

Try something like

Dim DataObj As MSForms.DataObject
Set DataObj = New MSForms.DataObject
DataObj.SetText Text:=UserForm1.TextBox1.Text
DataObj.PutInClipboard


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy value of textbox to clipboard for use in another application 5
Pasting from the clipboard 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Excel does not accept text format! 0
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003] 1
Copy unformatted value of cell via macro 0
Help with Clipboard 2
Copying cell text to clipboard (using Putinclipboard) 2

Top