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.