View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SuperJas SuperJas is offline
external usenet poster
 
Posts: 66
Default 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.