action on Double Click


Posted by John on January 17, 2002 7:24 PM

How do I get a macro to excecute when I double click a cell. I would like to open form using the data that is in the cell that was double clicked upon. Any help would be appreciated.

Thanks,

John



Posted by Ivan F Moala on January 17, 2002 8:33 PM

Excel 2K

Use Sheetevent:
eg.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$A$1" Then MsgBox "Doubleclick"
End Sub

Ivan