Modify Macro Code to include an extra Pop Up with different trigger

Hello excel peeps,

@judgeh59 and @Leith Ross brought my vision into reality with the code below.

However after running this today in live testing ... discovered that I would like one more pop up.

Looking to modify the following code to add an additional pop up - however needs a different trigger point then the other pop ups.

Please Login or Register  to view this content.

Trigger must be when Yes is selected in G .... Unlike the other pop ups that trigger when the date is entered in I

Message - Reminder add a correction date in Column I ... and select the cell in same row column I as the above do.

However if there is already a date in in column I no need to show popup.

Thanks in advance

Attached a test workbook in case needed.

this may get you in the right direction

Please Login or Register  to view this content.

Glad I could help....have a great day....