Change the "Delete" key to "BackSpace"

S

SuperJas

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top