Change the "Delete" key to "BackSpace"
 

Hi!

Is there a way I can use the OnKey function so that
whenever the user presses the "Delete" key, Excel thinks
that the "Backspace" key was pressed instead?

I need to do this for a Data Validation, since when I
uncheck "Ignore Blanks", Excel still ignores a 'deleted'
entry, whereas a 'backspaced' cell is treated correctly
(ie not ignored).

I've tried Application.Onkey "{DEL}", "{BS}" but it tries
to look up a procedure called BS...

Could someone please help?

Thanks very much in advance!

SuperJas.