moving to CLIPBOARD

  • Thread starter Thread starter jason
  • Start date Start date
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
 
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)
 
Back
Top