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

On 9/11/2010 8:12 PM, Ken wrote:
> 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

On 9/11/2010 10:51 PM, Mike S wrote:
> On 9/11/2010 8:12 PM, Ken wrote:
>> 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

Here's one more that may help:

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

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

On Sep 12, 1:51*am, Mike S <ms...@yahoo.com> wrote:
> On 9/11/2010 8:12 PM, Ken wrote:
>
>
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -