LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
cyrille
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy on double-click the cell value to Clipboard cyrille New Users to Excel 2 February 11th 05 11:29 PM
Change cell back color on click Dave Peterson Excel Discussion (Misc queries) 0 January 24th 05 10:50 PM
Keyboard shortcut for double click in Excell cell Katherine Excel Discussion (Misc queries) 10 January 13th 05 12:28 AM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"