Lookup using a list box

[lucas]

After thinking about the problem, I finally realized that I needed the listbox to make the selection for me on click.....

added this code and it works.

Private Sub lstSelection_Click()
Range("SelectionLink") = lstSelection.ListIndex + 1
End Sub

attached working ver. only first 9 artists-albums have tracks added, the rest return a 0 until I get the rest of the data added...

thanks for your feedback Jacob