Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error MOVING data: Cannot empty the clipboard | Excel Discussion (Misc queries) | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) |