Single clck --- double click
 

Hello,
How to detect that a user double clicked on the cell?
single click --just SheetSelectionChange()
double click --- SheetSelectionChange() and process the cell's data
How to do that?
Thanks,
Jack

Single clck --- double click
 

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)

If Target.Address = "$A$15" Then
MsgBox "hello!"
End If

End Sub

'=====================
:)
susan


On Oct 19, 10:42*am, "Jack" <replyto@it wrote:
Hello,
* * * * * How to detect that a user double clicked on the cell?
single click --just SheetSelectionChange()
double click --- SheetSelectionChange() and process the cell's data
How to do that?
Thanks,
Jack

Single clck --- double click
 

Thank you, Susan.
Jack

"Susan" wrote in message
...
Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)

If Target.Address = "$A$15" Then
MsgBox "hello!"
End If

End Sub

'=====================
:)
susan


On Oct 19, 10:42 am, "Jack" <replyto@it wrote:
Hello,
How to detect that a user double clicked on the cell?
single click --just SheetSelectionChange()
double click --- SheetSelectionChange() and process the cell's data
How to do that?
Thanks,
Jack