Worksheet_Change

[justuptou]

Under below coding, if I change any value in cell. the message box should be shown.
but the module has not been run, why ?

Private Sub Worksheet_Change(ByVal Target As Range)

　　Msgbox "A"


End Sub

[YasserKhalil]

This should be put in worksheet module not in standard module

[justuptou]

Yes, I have written the coding on that worksheet and also mark the "brown balloon" to check the each step status, but the coding was not run anymore.

[YasserKhalil]

Can you upload your workbook to see it?

[justuptou]

I add new file with data and coding, the new workbook is worked.

But it is still not worked on my old workbook

[YasserKhalil]

May be the workbook is corrupted ..