MsgBox that returns the information of another cell if a cell in a range contains certain value

  • Hi everyone!


    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.

    Joy :)

  • It's hard to work with a picture. Can you post a copy your file (de-sensitized if necessary)?

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • I assume that you want the message to pop up when you open the workbook.

    Place this macro in the code module for ThisWorkbook. Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, double click on "ThisWorkbook". Copy/paste the macro into the empty window that opens up. Close the window to return to your sheet. Save the workbook as a macro-enabled file. Close it and the re-open it.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.