Onkey Error

[SuperJas]

Hi!

In trying to reassign the "Del" key to the "Backspace" key, I've tried to program a procedure whenever the user presses "Delete".

I've placed the following lines of code within the Workbook_Activate event (which, as usual, resides in the "ThisWorkbook" section):
-------------------------------------------
Application.Onkey "{DEL}", "ClearCell"
-------------------------------------------

and then wrote a new procedure, still within the "ThisWorkbook" section:
----------------------------
Sub ClearCell()
ActiveCell.ClearContents
End Sub
----------------------------

However, when I press the Delete key, Excel says that the macro couldn't be found!

Could someone please help?

Thanks!

SuperJas.

 

[J.E. McGimpsey]

One way:

Put ClearCell in a regular code module.