Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to copy on double-click the cell value to Clipboard
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Keyboard shortcut for double click in Excell cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |