to execute a macro when any cell value changes

[Guest]

Can anyone tell me the codes that will execute an already existing macro when any cell value is changed in the worksheet. I think it uses Change event but I can figure out the exact codes. How would private sub affect my macro?

Thanks
VS

 

[Tommy Bak]

try this one. click on the sheet tab, ´click view code and paste it

Private Sub Worksheet_Change(ByVal Target As Range)
Call anothermacro
End Sub