Forum Discussion

Wanda Moyer's avatar
Wanda Moyer
Copper Contributor
Apr 13, 2018

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 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.

 



 

Macros & VBA
Need Help

1 Reply

  • Mark Fitzgerald's avatar
    Mark Fitzgerald
    Iron Contributor
    Apr 24, 2018

    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.