Msgbox to show value of 2 cells if a value in another cell

Hi all

This is very good forum and have found it very helpful loads of time and i wonder if anyone can help with one my problems i've been scratching my head over.

I want a MsgBox to popup if any of the cells in a range eg a1:a100 have a value equal to or greater then 14. I want the MsgBox to show the value of 2 other cells: I have the current codes if any can help:

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

You didn't indicate what the "other 2 cells" would be if A15 were > 14, so this is a starting point for you.

Thank you Jbeaucaire;

I don't think I explained my self well.

What i'm trying to do is if a cell in range A1:O8 is >= 14 then it is going to pop a message box and instead of it showing the c.address in the msgbox I want it to show the time value from another cell and date value from antoher cell from the cell where the value is >=14

I've attached a draft to show what i'm trying to do.

so after having a look at the attachment if you have time it would be great help, and it will make more sense what i'm saying.

Eg. if cell L4 is greater or equal to 14 then the messgbox will popup and show the message " too many students" and also the value of J4 and L1.

These sheet gets updated everyday so next time a cell can be greater or = 14 in M2 and then again i want it to show the value of J2 and M1 in the message box etc

I hope that makes sense cos i'm pulling my hair out searching for this solution.

Thanks again for helping already.

Originally Posted by JBeaucaire

Maybe:

Please Login or Register  to view this content.

You didn't indicate what the "other 2 cells" would be if A15 were > 14, so this is a starting point for you.

Like so:

Please Login or Register  to view this content.