moving to CLIPBOARD
 

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

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

moving to CLIPBOARD
 

Cheers Chip

(not exactly intuitive is it?!)

Jason

"Chip Pearson" wrote in message ...
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