Hi, I need to programmatically override the following events of a worksheet:

• BeforeDoubleClick
• SelectionChange
• BeforeRightClick

I have been able to override the OnActivate event using the following code:

sheet.OnSheetActivate = "MyOwn_Activate"


Private Sub MyOwn_Activate()

    myForm.Show

End Sub

I have implemented BeforeDoubleClick on similar lines:

sheet.OnDoubleClick = "My_BeforeDoubleClick"

Private Sub My_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
...
End Sub

However, an 'argument not optional' error is thrown at run-time when user double clicks a cell on the sheet. Can someone please suggest how should I pass the paramters?

In addition, I am not able to find event names for SelectionChange & BeforeRightClick. I tried:

sheet.BeforeRightClick = "My_BeforeRightClick"
sheet.SelectionChange = "My_SelectionChange"

But, both the above lines do not work.

Any help/ suggestion is greatly appreciated.

Thanks :)