Record button press on worksheet change

[Glory]

Is there a way to record which button the user pushed?

Eg, if the user pushes delete in a certain range, clear a certain other range.

 

[Glory]

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Application
a = Application.OnKey([Del], MyChange)
End Sub
 
Private Function MyChange()
MsgBox "Hey"
End Function

This returns "Expected function or variable" for the OnKey part... even though it's available to VBA through intellisense.


...And when I use this, the UDF triggers no matter what I type, and then I get "Object doesn't support property or method".

a = Application.Worksheetfunctions.OnKey([del], MyChange)

 

[Glory]

See this thread for a user defined function that does the works:

http://www.mrexcel.com/forum/showthread.php?t=181654

 

[Jaafar Tribak]

Glory,

Better not to use the code in the link as it is not stable in XL2007 and can potentially crash excel. I'll try writing a new and more stable code to simulate an OnKey event for cells later on.

As for your code I think it should be like this :

Private Sub Worksheet_Change(ByVal Target As Range)
    Call Application.OnKey("{DEL}", Me.CodeName & ".MyChange")
End Sub
 
Private Function MyChange()
    MsgBox "Hey"
End Function

 

[Glory]

Thank you very much...

I'm using "Center across selection", which causes some text to appear to be located in a cell it's not. So when people click the cell they think the text is in and try to delete it, now the text will go away.

Thanks again.