Lookup using a list box

[Jacob Hilderbrand]

Lets say you have the track info in Column H as you indicte with this code:

Private Sub lstSelection_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
MsgBox Worksheets("SalesCatalog").Range("H1")
End Sub

So Row 1 corresponds to listbox listindex 0 (since the listindex starts at 0)
So then Row 2 should have the data for the second choice from the listbox etc.

change the code a bit to make the row a variable

Private Sub lstSelection_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
MsgBox Worksheets("SalesCatalog").Range("H" & lstSelection.ListIndex + 1)
End Sub