Hi

I have a report on sheet2 with data fetched from sheet1. What I want is that after someone input data in sheet1 and switch to sheet2, a Macro named "comment" will run. I found this code which is for an identical situation, but where do I get to choose which macro to run?


Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Thank you
Kun