Adding a notification box when conditions are met in Excel

I suggest adding another column called "Open Problem" and set it to 1, or other numbers to indicate importance. Clear this cell when the problem is resolved. Sort on this column to bring open problems to the top.

This will be easier than implementing a notification, and you have to find the customer records anyway.

I suggest that you just look at the top N rows of the sorted sheet, rather than popping up a box that lists the names of the top N rows.

Your worksheet can have a menu item that runs the appropriate sort on the Open Problem column, and even the age of the problem or other criteria that make the problem more urgent.

If you can post your workbook or a sample, I could install such a sort procedure and its button. The sort could run automatically upon opening the workbook, if pushing the button is a pain. (smile)