Copy to clipboard not working

[Asrampd]

Hi,

The intention is to double click on any part of a Row (E.G. Row "E") and to copy to the clipboard the contents of the first cell (E.G. "E1") and then release the highlight -whilst retaining the clipboard content for use in another application.


What am I doing wrong - It copies the 1st time, it gets the cell hit, it then does not work but edits the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range)
'/force active cell to be the first in the row
Range("A" & Target.Row, "E" & Target.Row).Select
Target.Copy
Application.CutCopyMode = False
End Sub

Thanks

 

[VoG]

Try

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
'/force active cell to be the first in the row
Range("A" & Target.Row, "E" & Target.Row).Copy
End Sub

 

[Asrampd]

Yes that works, what can be added to deselect the line afterwards ?

 

[VoG]

You can use Application.CutCopyMode=False but only after you have pasted the data somewhere.

 

[Asrampd]

Oh, that is not what I want to do.

 

[Asrampd]

The Idea is to put the contents of the selected cell into the Windows Clipboard, then clear the screen for the next selection.

Meanwhile - or when ready, the user goes to a third party software and pastes in the copied instruction (a Typical phrase would be "S1(D,N,!<>2.5E") to an input field.

Ta.