| 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) | |||
Linear Mode
