Message box that returns a cell value if a criteria is met.

[samdegg]

Hello,

I have the following code:

Please Login or Register  to view this content.

This section

Please Login or Register  to view this content.

returns the cell that the date has passed in.

I would like it to return a different cell value in the message box, for example if J4 has passed its date, then B4 cell value is put in the message box instead.

Thank you for the help in advanced.

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[samdegg]

Thank you for your response but that only returns B9 in the message box. If cell B9 contains Joe Bloggs, I would like to say Please review the date for Joe Bloggs......

[samdegg]

I have sorted it now. I have used:

Please Login or Register  to view this content.