Worksheet_Change issue

Copper Contributor

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 of the code that produces 2 messages saying "send email now".  Have circled the code that is doing this in red in the attachment. 

 

Thank you for any help you can provide where I am going wrong.

 



 

1 Reply

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.