Single clck ---> double click

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
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
 
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
 
Back
Top