#1
|
|||
|
|||
Listbox or Combobox population
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.. Last edited by wannaExcel; 04-06-2019 at 11:43 AM. Reason: Attaching File |
#2
|
||||
|
||||
Could you please post your sheet with some data and what you have already accomplished?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Listbox or combobox population
Sorry I may have done that wrong but if you look at original post I attached a file there.
So I am doing a database of my CD collection, now I love Excel but has been a while since I have worked in it like this, so I am rusty and MS has taken a lot of things a way.. Any ways once I add the CD's to my list I would like to go back and edit them as to whether I have them as an MP3 format. I have not gotten to the Option buttons yet so those on frmEdit don't work yet. So because most artist and or groups have more than one album I would like to populate the cboAlbum with all albums corresponding with the artist in cboArtist, but I will only select 1 Album at a time to update. Hope that explains a bit more. And thank you for your quick reply. |
#4
|
||||
|
||||
Made a few minimal alterations/additions to your code in the attached.
|
#5
|
|||
|
|||
You my friend are a genius. I never thought of making another collection. I'm slowly getting back into this so once again thank you Thank you for the quick response..
|
Tags |
excel vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Template - Selectable Image Population | Einstein2000 | Word VBA | 1 | 10-17-2017 05:27 PM |
This is a Userform LIstbox queston: A variable does not set to the value of a listbox | CatMan | Excel Programming | 14 | 08-18-2014 08:14 PM |
This is a Userform LIstbox queston: A variable does not set to the value of a listbox | CatMan | Excel | 1 | 08-08-2014 09:41 AM |
Auto population of a single date | bremen22 | PowerPoint | 1 | 08-04-2014 11:59 AM |
Automating Cel Population of .jpg | skoz55 | Excel | 0 | 01-21-2009 03:43 AM |