Display Active Cell Values in MsgBox

[f00dFights]

This is one that has stumpted me for a while but can anyone tell me how to display an Active Row in a message box?
I have a table with three columns and when i select one cell i need to return the row values in a MsgBox (so for instance if i select A7; it should return A7, B7 and C7)

Id appreciate any help

 

[mohadin]

This code in sheet code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    With ActiveCell
        MsgBox .Value & "/" & .Offset(, 1) & "/" & .Offset(, 2)
    End With
End Sub

DoubleClick the Cell

 

[f00dFights]

This code in sheet code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    With ActiveCell
        MsgBox .Value & "/" & .Offset(, 1) & "/" & .Offset(, 2)
    End With
End Sub

DoubleClick the Cell

Hi,
i forgot to mention the data is being pulled into a listbox via RowSource. I tried your suggestion in the relevant sheet and the image is the output