how to copy on double-click the cell value to Clipboard

  • Thread starter Thread starter cyrille
  • Start date Start date
C

cyrille

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
 
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.
 
After double clicking to access the cell contents, Click ctrl and c. To
paste click ctrl and v. This works in almost any Windows application.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy the value of cell into clipboard by double click 2
Color 8 cells on DBL click 2
Double Click Cell to Run Macro 2
Double click fails to run the code, just selects the cell 12
Trying to run excel vba code when cell value changes from empty to entered value. 1
Scroll 8
Doube click cell to run macro 1
Excel Providing user message when RED X clicked & properly closing application. 2

Back
Top