mrlemmer11
New Member
- Joined
- Jun 8, 2015
- Messages
- 32
Hello,
I've been trying all sorts of combinations for the past 4 hours and just can't get this right.
Lets say my ultimate goal is to have 3 VBA listboxes. The first is Band, the second is Album, and the third is Song. The user selects one of the ten bands from listbox one, and then listbox 2 populates with albums which match that band. Now they select an album and listbox three displays the songs on that album.
In excel, i have 357 rows by 3 columns. column A lists the bands, column b lists the albums and column c lists the songs.
So how do i get it so that Listbox 1 in vba doesn't show 357bands, rather only 10, listbox 2 understands which albums are tied to the band selected and listbox 3 understands which songs are tied to the album selected?
thank you ever so much.
I've been trying all sorts of combinations for the past 4 hours and just can't get this right.
Lets say my ultimate goal is to have 3 VBA listboxes. The first is Band, the second is Album, and the third is Song. The user selects one of the ten bands from listbox one, and then listbox 2 populates with albums which match that band. Now they select an album and listbox three displays the songs on that album.
In excel, i have 357 rows by 3 columns. column A lists the bands, column b lists the albums and column c lists the songs.
So how do i get it so that Listbox 1 in vba doesn't show 357bands, rather only 10, listbox 2 understands which albums are tied to the band selected and listbox 3 understands which songs are tied to the album selected?
thank you ever so much.
