Category Archives: Worksheet_Change Event

How To Trigger An Excel VBA Event When Cell Value Is Deleted

This post actually was birthed from a comment made on one on my Youtube videos:

I wanted to know as how to trigger an event when a cell value is deleted?

(a comment to this post’s video: http://www.vbastring.com/blog/how-to-run-a-macro-when-cell-value-changes-in-excel-vba/)

So we are going to trigger an Excel VBA event when a value is deleted from a cell.

In the above screen shot we have a fake list of names in column A of the worksheet.

We are deleting the value from Cell “A4”, and we are adding a little confirmation message to confirm to the user that that’s what they want to do.

If we click “Yes”, the old value (existing value) gets “deleted” (substituted) with the current value (a blank value).

Do you have questions?

Let me know. Also, share this with someone else.

Facebooktwittergoogle_plusredditpinterestlinkedinmail
READ MORE