Worksheet_Change: Not triggered when user deletes a cell's content

Hey there,

I probably have an easy one for you.

I use the Worksheet_Change method and want to trigger a sub in case a specific cell is "x" or "".
No problem with the "x", but if the user deletes the "x" (which should also trigger the macro since the cell's content is "" afterwards) nothing happens. It turns out, the Worksheet_Change-Event is not even called!

How to deal with this issue? How to call the Worksheet_Change-Event if the user deletes the cell's content?

Thanks a bunch!
Klaster

Hi,
thanks for your replies.
The Worksheet_change-Event was actually called - I forgot to comment out my error-catching line.

Still, I get an error in the following section, when I delete the cell's content. Here is the relevant code.

The MsgBox works fine (since I changed Target.Value to Target.Text), but the code throws a 13-Error at the If-Statement.
I tried IsEmpty(Target), IsEmpty(Target.Value) and IsNull(Target) instead of Target.Text = "" as well. How else could I check for an empty cell?

Please Login or Register  to view this content.

Thanks in advance!
Klaster

Hey Holger,

thanks for your input. I tried your solution and it didn't work either. Seems as the problem was the "Or"-Statement. Breaking it down into two ElseIf-Statements "solved" the problem . Well, it's a workaround.

Thanks for your replies! I like this forum!

I won't set the thread to "solved" as the problem itself isn't really fixed.