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
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
This should be put in worksheet module not in standard module
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.
Can you upload your workbook to see it?
I add new file with data and coding, the new workbook is worked.
But it is still not worked on my old workbook
May be the workbook is corrupted ..