Thread: Copy text then Past Text into TextBox not working
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_4_] Jean-Yves[_4_] is offline
external usenet poster
  
Posts: 27
Default 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
Reply With QuoteReply With Quote