Copy text then Past Text into TextBox not working

R

RyanH

How can I copy text from another application (Microsoft Word) and then paste
it into a UserForm Textbox?

Thanks in Advance,
Ryan
 
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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy text from textbox to another application 3
Copy value of textbox to clipboard for use in another application 5
Userform textbox string to header causes unwanted double spacing 4
Textbox form to Textbox in worksheet 4
AutoFit Row Size with Merged Cells 2
Firing Event in another user form 1
TEXTBOX COPY AND FORMAT !! 3
finding where text wraps in a textbox 4

Top