Forum Discussion
Pop up reminder based when specific wording is present (VBA or Macro?)
I am trying to create a pop up message/reminder/alert when certain projects read "Overdue" in certain cells. Is there a simple formula or code that can notify when a cell reads Overdue? Once I...
I appreciate your response but I have a rather large set of data and it would be much easier to have a pop up that can tell me where there is the Overdue cell - vs. having to scroll and "un-hide" cells/columns to search for them - even though they are highlighted RED and do stand out - it would still take me quite sometime to search the entire sheet/workbook for Overdue items -
but thank you so much for your input.
but thank you so much for your input.
baugustadt Well you can add the address of where the Overdue item was found. In the attached I added that formula and also the corresponding macro. The advantage of the macro is it will also select that first found item (and scroll to it)