Single clck ---> double click

J

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
 
S

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
 
J

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
 
Top