How to avoid running userform if there's not date on particular column?

Giday to you all

I'm trying to create a spread sheet for the supervisor so he can keep track of all the work orders he sent.

I have succussfully made all the userforms to appear if the date is out of due in Column E.

But trouble is if there is no date, an error will appear so I have to enter a hidden date in E2.

Is there any way to avoid userforms to appear if there is no dates from E3?

Thank you in advance.

Attachment 237652

Just add another If/Then.

Please Login or Register  to view this content.

Hi Tinbendr

Thank you for replying but there's bug in the code in Workbook.

Can you have another look please? Thank you very much

Don't use Userforms for something as simple as popping up a message for an OK click. Also, better to mark these events as the sheet is activated by the user rather than a bunch of popups when the workbook is opened.

I've changed your DUEDATE macro to one that accepts two parameters: The name of the worksheet and the number of days to offset. In each sheet module there is now a simple "Activate" macro that will call the DUEDATE macro when the sheet is activated. It will color the dates older than the offset you've chosen and color them red IF they are not already red. If they are already red, they will not be painted again nor will they trigger the popup message.

You'll also notice you no longer need a fake date in E2 to start.

Update:

Thank you very much for your help JBeaucaire, much appreciated.

and thank you for your time

Cheers

Unley