View Full Version : [SOLVED:] Worksheet_Change
justuptou
03-04-2017, 03:55 AM
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
03-04-2017, 04:13 AM
This should be put in worksheet module not in standard module
justuptou
03-04-2017, 04:58 AM
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
03-04-2017, 05:08 AM
Can you upload your workbook to see it?
justuptou
03-04-2017, 11:05 AM
I add new file with data and coding, the new workbook is worked.
But it is still not worked on my old workbook
YasserKhalil
03-04-2017, 11:42 AM
May be the workbook is corrupted ..
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.