Apr 13 2018
07:28 PM
- last edited on
Jul 25 2018
09:56 AM
by
TechCommunityAP
Apr 13 2018
07:28 PM
- last edited on
Jul 25 2018
09:56 AM
by
TechCommunityAP
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.
Apr 24 2018 06:39 PM
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.