Private Sub Worksheet_Change(ByVal Target As Range) End Sub

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?

Please Login or Register  to view this content.

Thank you
Kun

Put this in Sheet2's code maybe?

Please Login or Register  to view this content.

Thanks, millz.