Hi,
does anybody know how to catch the dblclick event on any cell in an .xla
(AddIn)? I wrote some workbook functions and want to be notified if any of
my functions is double clicked.

Thanks,
Marco

Hi Marco,

You need to use application events.

First, in your addin, add a class module say called clsAppEvenrts.

In the ThisWorkbbok module, add this code


Dim AppClass As New clsAppEvents

Private Sub Workbook_Open()
Set AppClass.App = Application
End Sub

and then in the class module add this code

Public WithEvents App As Application

Private Sub App_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As
Range, Cancel As Boolean)

End Sub

and add the code in there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Marco" wrote in message
...
Hi,
does anybody know how to catch the dblclick event on any cell in an .xla
(AddIn)? I wrote some workbook functions and want to be notified if any of
my functions is double clicked.

Thanks,
Marco

Where would your functions be when they are double clicked? In otherwords,
where is the user doubleclicking?

--
Regards,
Tom Ogilvy

"Marco" wrote in message
...
Hi,
does anybody know how to catch the dblclick event on any cell in an .xla
(AddIn)? I wrote some workbook functions and want to be notified if any of
my functions is double clicked.

Thanks,
Marco

Bob,
many thanks. It works!

Marco

The user is doubleclicking any cell that may contain one of the functions I
wrote.

"Tom Ogilvy" schrieb im Newsbeitrag
...
Where would your functions be when they are double clicked? In
otherwords,
where is the user doubleclicking?