Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-06-2019, 12:00 AM
wannaExcel wannaExcel is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2014
Posts: 9
wannaExcel is on a distinguished road
Default 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..
Attached Files
File Type: xlsm My CD's (v1.5)_1.xlsm (31.9 KB, 1 views)

Last edited by wannaExcel; 04-06-2019 at 11:43 AM. Reason: Attaching File
Reply With Quote
  #2  
Old 04-06-2019, 08:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,386
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Could you please post your sheet with some data and what you have already accomplished?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 04-06-2019, 11:50 AM
wannaExcel wannaExcel is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2014
Posts: 9
wannaExcel is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 04-06-2019, 02:30 PM
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 253
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Made a few minimal alterations/additions to your code in the attached.
Attached Files
File Type: xlsm msofficeforums42173My CD's (v1.5)_1.xlsm (31.0 KB, 1 views)
Reply With Quote
  #5  
Old 04-06-2019, 02:53 PM
wannaExcel wannaExcel is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2014
Posts: 9
wannaExcel is on a distinguished road
Default

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..
Reply With Quote
Reply

Tags
excel vba

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 10:52 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft