If statement with conditions on some....

Hello everybody.

I need to achieve the following;

When executing macro Check_Info I want to check if cell AR1 is missing and return info msg Customer Name is missing, then stop running macro, I AR1 has data then check if cell W17 is empty, if so return info msg Delivery date is missing. Then a condition statement would you like to carry on wihout a delivery date? If yes then continue running macro if not then stop macro (I believe End Sub???? If carry on then check next cell AW17 if empty then info msg Processed By field is empy, and stop running macro.

What am I doing wrong here?

I have managed to have msg error for Customer name empty but this is only showing when there is data in the cell?

Any help appreciated.

Regards,
Albert

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

How about:

Please Login or Register  to view this content.