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

[SVTF]

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.

[judgeh59]

this may get you in the right direction

Please Login or Register  to view this content.

[SVTF]

Once again perfection - Thank you so much.

As soon as I give you some more rep I will.

[judgeh59]

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