vba popup message to notify empty cell

[bqheng]

Hi, attached workbook is a common file used for data entry by a few of my staff. At some point in time, they will need to move files into another drive and check off Column Q after they have done so. The problem is, they sometimes forget to move the files due to their busy schedule. What i hope to add to this workbook is a code that can check if Column Q has been checked everytime the workbook is opened. If it has not been checked, look up column Column G and add 5 days to it. So the popup message will appear on the 5th day onwards, everyday, until the files have been moved and Column Q has been checked off.

The popup message ideally should have the case number (located in Column A) and the tab name, if not it will be time consuming to look through every sheet to find the problematic row.

Any help is appreciated

[LJMetzger]

Hi bqheng,

See the attached file (containing the code below) which is a modified copy of your Workbook. A UserForm is displayed when the Workbook Opens that contains a list of each item that is 5 or more days overdue. 'Double Clicking' any item in the List, will go to that item.

To display the list again, 'Double Click' cell 'R1' (TAT) on any sheet.

In the ThisWorkbook code module:

Please Login or Register  to view this content.

In the UserForm1 code module:

Please Login or Register  to view this content.

In ordinary code module ModUserForm1:

Please Login or Register  to view this content.

Lewis

[bqheng]

Thank you LJMetzger!!