Forum Discussion
Wanda Moyer
Apr 13, 2018Copper Contributor
Worksheet_Change issue
Hi, I have created a Private sub Worksheet_change in my spreadsheet and the STAGES portion applies two messageboxes instead of one like the STATUS portions. Not sure why. It is the "ChkCell" part ...
Mark Fitzgerald
Apr 24, 2018Iron Contributor
Hi Wanda,
When you write the date in Range("BV" & ActiveCell.Row) it triggers WorkSheet_Change again!
You can confirm this by placing a break-point at the first line of your code and stepping through using F8.
You can avoid cascading WorkSheet_Change events firing by setting
Application.EnableEvents = False
as soon as you enter your event handler procedure then reset it to True at the end of the procedure.