R
RyanH
How can I copy text from another application (Microsoft Word) and then paste
it into a UserForm Textbox?
Thanks in Advance,
Ryan
it into a UserForm Textbox?
Thanks in Advance,
Ryan
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nigel
Put cursor in textbox and press Ctrl V
J
Jean-Yves
Voila
Dim daoStr As DataObject
Dim strCB As String, strTemp As String
Set daoStr = New DataObject
daoStr.GetFromClipboard
strCB = daoStr.GetText
textbox1=strCB
HTH
Dim daoStr As DataObject
Dim strCB As String, strTemp As String
Set daoStr = New DataObject
daoStr.GetFromClipboard
strCB = daoStr.GetText
textbox1=strCB
HTH
R
RyanH
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
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
J
Jean-Yves
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.
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.