View Single Post
  #2   Report Post  
pep819
 
Posts: n/a
Default

Hi Cyrille,

Just double click, then click ctrl and c. To paste the data, click ctrl and
v. This works on almost any Windows application.

"cyrille" wrote:

Hello everybody,
My question is in the title... I just want to be able to automatically
copy the text content of one selected cell (selected by double-click)
into the Clipboard. Can you help me?
I tried something like the following, but it doesn't work.
Thanks in advance
Cyril

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
On Error Resume Next
If ActiveCell.Value < "" Then
ActiveCell.Value.Copy
End If
Cancel = True
End Sub