View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
susan hayes susan hayes is offline
external usenet poster
 
Posts: 31
Default How to disable the delete key after deletion is made

Hello again

If the user presses the delete key to delete something entered, my program executes which I dont want. How can you
simply have the value deleted and then exit sub for example so the program doesnt continue further.

I have tried

Application.OnKey "{delete}" ', "matrix" ' not quite what Im looking for

if .Value = vbKeyDelete Then ' this does nothing
Exit Sub
endif

Thanks
Mike