VBA change macro

[mrmaso]

Hello,
I need help with some macro. I would like to have in one sheet change macro which will erase one cell if one cell will be change. For example:
if sell G4 will be changed then the contain of the cell O5 will be erase.

Thank you.

 

[Scott T]

Right click on the tab you want the code to run in.
Select view code
past the code below in the sheet
You will need to save the file as a macro enabled file type such as .xlsm

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = Range("G4").Address Then Range("o5").ClearContents
End Sub

 

[mrmaso]

Thank you a lot... it is working.