I have a spreadsheet with Artist/Group ("B:B") and Album ("C:C").



Now I have a userform with 1 combobox and 1(either Listbox or ) another combobox haven't decide which would be best. What I would like to do is populate the 2nd combobox(listbox) with the albums from the artist combobox.

Now for one Artist there could be and usually are more than 1 album is it possible to do this? And if so could someone point me in the right direction on how I could do this.


My apologize if this is posted somewhere else I have tried looking couldn't find..

Attached Files

My CD's (v1.5)_1.xlsm (31.9 KB, 8 views)