How to disable the delete key after deletion is made

[Susan Hayes]

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

 

[Myrna Larson]

Do you mean that you have a Worksheet_Change event macro that you don't want
to run if the user has cleared the cell? If so,

Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target.Value) Then Exit Sub
'your code goes here
End Sub

Hello again

If the user presses the delete key to delete something entered, my program

executes which I dont want. How can you