If cell is deleted, can this initiate an action?

[RobertBon]

Hello,

Is there a function in vba that will perform an action, once a specific cell (or range of cells) is deleted. So: "if cell "whatever" is deleted, than perform "this" action"

In the worksheet_change I've already tried:
If target.value = "" Then;
If target.value = vbNullString Then;

but I feel they're not the best options, are there any other methods?

 

[tweedle]

Take a look at Intersect

Private Sub Worksheet_Change(ByVal Target As Range)
Set isect = Intersect(Range(Target.Address), Range("B7"))
If Not isect Is Nothing Then
    'a/k/a how to annoy   
    Application.EnableEvents = False
    Application.Undo
    Range("B7") = "Can't get rid of me!!!"
    Application.EnableEvents = True
End If
End Sub

 

[RobertBon]

I'm using intersect in my code already. I didn't try that "address" method though. What does Range(target.address) mean? And why do you have application.undo

curious.

 

[tweedle]

What does Range(target.address) mean?

It means I don't get a type-mismatch error on using just 'Target'.

And why do you have application.undo

demonstration purposes
If the user tries to change/clear contents/delete the value of a cell that I don't want them to, I change it back.
[One can delete/insert a row/column to move the 'protected' cell out of this rule; but that too can be locked; and most don't care to hose the functionality of the workbook anyway.]

 

[RobertBon]

Thanks Tweedle!