| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change syperlink from single click to double click | Excel Worksheet Functions | |||
| Change single click to double click | Excel Programming | |||
| userform label double-click goes to click event | Excel Programming | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Linear Mode
