Archive of Mr Excel Message Board

Back to Excel VBA archive index
Back to archive home

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

Check out our Excel VBA Resources

Re: action on Double Click

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.