VBA - Clear cell when a change is made in another cell.

[garypea123]

Good Morning,

Should be a nice easy one.

I am looking for a VBA which will clear the information in B7 every time there is a change in B4...

Thank you as ever in advance

 

[Joe4]

Right-click on the sheet tab name at the bottom of your screen, select "View Code", and paste this VBA code in the VB Editor box that shows up:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B4")) Is Nothing Then
        Application.EnableEvents = False
        Range("B7").ClearContents
        Application.EnableEvents = True
    End If
End Sub

This will automatically clear our cell B7 whenever you make a change to cell B4.

 

[garypea123]

Perfect - Works like an absolute dream.

Thank you very much - Star!!

 

[Joe4]

You are welcome.
Glad I was able to help!