Thank you so much for your help Mumps
I can't share the file. It would be something like this one on the attached though.
The important bits are the ones in blue.
I am trying to create a MsgBox that will pop up a notification for all cases I must follow up in the day. Please see the requirements:
1. Should run automatically once I open the spreadsheet.
2. If the text PLEASE SEND NOTIFICATION" is present on range CE3:CE1000, then the MsgBox should inform returning the reference numbers (in this example Ref 01 and Ref 05)
3. The message box should contain an exclamation mark
The final message would be then "Please send notification regarding Ref 01 and Ref 05".
Thank you in advance.