Thread
:
moving to CLIPBOARD
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
moving to CLIPBOARD
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
"jason" wrote in message
om...
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson