copy text from textbox to another application

[Ken]

I have a worksheet with several textboxes and command buttons next to
them. The buttons have the following code:

Private Sub CommandButton1_Click()

Dim str As String

str = ActiveSheet.TextBox1.Text
Range("d1").Value = str
Range("d1").Copy

End Sub

The purpose of this is to copy the code from the textbox and paste
into a medical application called Road Notes. The code works fine for
copying and pasting with control V to another cell or a Word document;
but control V will not paste it into Road Notes. I would tend to
think that there was some Windows compatibility issue with Road Notes,
but, if I click on the textbox, then control A, then control C, then
switch to the applicable entry field in Road Notes, control V pastes
the text fine.

What is the difference between copying the text from a cell for
subsequent pasting and putting the text on the clipboard with control
C for subsequent pasting?

Thanks

Ken

 

[Mike S]

I have a worksheet with several textboxes and command buttons next to
them. The buttons have the following code:
Private Sub CommandButton1_Click()
Dim str As String
str = ActiveSheet.TextBox1.Text
Range("d1").Value = str
Range("d1").Copy
End Sub

The purpose of this is to copy the code from the textbox and paste
into a medical application called Road Notes. The code works fine for
copying and pasting with control V to another cell or a Word document;
but control V will not paste it into Road Notes. I would tend to
think that there was some Windows compatibility issue with Road Notes,
but, if I click on the textbox, then control A, then control C, then
switch to the applicable entry field in Road Notes, control V pastes
the text fine.

What is the difference between copying the text from a cell for
subsequent pasting and putting the text on the clipboard with control
C for subsequent pasting?

Thanks

Ken

Using The Clipboard In VBA

http://www.cpearson.com/excel/clipboard.htm

 

[Mike S]

Using The Clipboard In VBA

http://www.cpearson.com/excel/clipboard.htm

Here's one more that may help:

http://word.mvps.org/FAQs/MacrosVBA/ManipulateClipboard.htm

 

[Ken]

Thanks Mike. I have gotten a lot of great stuff from Chip's site
before. This is another.
Ken