Invoice Date Pop up Issue VBA

[wolverine21]

I'm trying to create a macro that will populate a message box automatically if a date has passed. I have this part figured out. However, I added a second line to show that I invoiced for this item. I'm trying to figure out how to change the macro to not populate t he message box if I've invoiced for the item. I've created a second row to show that I've populated the date it was invoiced for.

[rollis13]

Have a try with the change I made in your macro so it will also test the cell (K2) below to check if it's empty.
I also hope that your are aware that your macro will test only cell K1, you need to add a loop to cycle from K1 to N1 (and beyond).

Please Login or Register  to view this content.

[wolverine21]

How would I include K1 to N1?

[rollis13]

Oh, you didn't even had a try by yourself, so, this could be a solution.

Please Login or Register  to view this content.