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.
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.