Message box with cell value in the message

I am trying to make a message box pop up when a value is entered in a cell range and have the message show the value in a corresponding cell range.

I've got Flight numbers in column $B7 and Departure times in column $J7.
When a departure time is entered I want a message box to pop up with a message that the corresponding flight has departed.
For example, if the Departure time is entered in J13, I want the message to include the Flight number in B13.

This is what I have:

Please Login or Register  to view this content.

I know the error is in & Range("B7:28").

Thank You!

edit: formatting

Hi GCHVFX,

Welcome to the forum!!

Please wrap any code you post in the future with the appropriate tags as it's a requirement of the forum (refer Rule 2 here which you've just agreed to ). As this is your first post a moderator will do it for you this time.

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert