See if this does what you want

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox _
ActiveCell.Offset(0, 15) & vbCrLf & ActiveCell.Offset(0, 16) & vbCrLf &
ActiveCell.Offset(0, 17) & vbCrLf & ActiveCell.Offset(0, 18)

End Sub

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"North Tim" wrote in message
...
Is there a way to show detailed data (i.e. concatenated from other
columns)
in a pop-up box - either by clicking or rolling over a cell?

For example, when a user rolls over or clicks cell E5, I'd like a popup
ballon/box to display cells T5, U5, V5, W5, etc with line breaks after
each.

I've searched and found solutions for displaying help messages (e.g.
validation input message) or pictures, but not data. Thanks for your help.