Single clck ---> double click

[Jack]

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

 

[Susan]

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

 

[Jack]

Thank you, Susan.
Jack

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