| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy text then Past Text into TextBox not working
How can I copy text from another application (Microsoft Word) and then paste
it into a UserForm Textbox? Thanks in Advance, Ryan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text then Past Text into TextBox not working
Put cursor in textbox and press Ctrl V
-- Regards, Nigel "RyanH" wrote in message ... How can I copy text from another application (Microsoft Word) and then paste it into a UserForm Textbox? Thanks in Advance, Ryan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text then Past Text into TextBox not working
Voila
Dim daoStr As DataObject Dim strCB As String, strTemp As String Set daoStr = New DataObject daoStr.GetFromClipboard strCB = daoStr.GetText textbox1=strCB HTH -- Regards Jean-Yves Tfelt Europe "RyanH" wrote: How can I copy text from another application (Microsoft Word) and then paste it into a UserForm Textbox? Thanks in Advance, Ryan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text then Past Text into TextBox not working
Nigel,
Ctrl-V seems to work. Is there a way to right click then select Paste? Jean-Yves, Where do I place this code? Do I have to do this for every textbox? Thanks Ryan "Jean-Yves" wrote: Voila Dim daoStr As DataObject Dim strCB As String, strTemp As String Set daoStr = New DataObject daoStr.GetFromClipboard strCB = daoStr.GetText textbox1=strCB HTH -- Regards Jean-Yves Tfelt Europe "RyanH" wrote: How can I copy text from another application (Microsoft Word) and then paste it into a UserForm Textbox? Thanks in Advance, Ryan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text then Past Text into TextBox not working
Hi Ryan,
If this is for multiple textboxes, then better stick to keyboard comands. The code I showed you should be used for one textbox only. I used a comanddbutton Or you have to trace which control has the focus.If Interested, google on traceFocus. -- Regards Jean-Yves Tfelt Europe "RyanH" wrote: Nigel, Ctrl-V seems to work. Is there a way to right click then select Paste? Jean-Yves, Where do I place this code? Do I have to do this for every textbox? Thanks Ryan "Jean-Yves" wrote: Voila Dim daoStr As DataObject Dim strCB As String, strTemp As String Set daoStr = New DataObject daoStr.GetFromClipboard strCB = daoStr.GetText textbox1=strCB HTH -- Regards Jean-Yves Tfelt Europe "RyanH" wrote: How can I copy text from another application (Microsoft Word) and then paste it into a UserForm Textbox? Thanks in Advance, Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Past Values AND Formatting AND Text | Excel Discussion (Misc queries) | |||
| Copy TextBox Text | Excel Programming | |||
| Find Text from textBox then past what is found on sheet1 | Excel Programming | |||
| Copy/paste text in cells into a textbox | Excel Programming | |||
| How to copy text from a TextBox in a ActiveSheet to a variable | Excel Programming | |||
Linear Mode
