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