Microsoft Office Forums Listbox or Combobox population

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2019, 12:00 AM
wannaExcel wannaExcel is offline Listbox or Combobox population Windows 7 64bit Listbox or Combobox population Office 2016
Novice
Listbox or Combobox population
 
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 Listbox or Combobox population Windows 7 64bit Listbox or Combobox population Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,398
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 Listbox or Combobox population Windows 7 64bit Listbox or Combobox population Office 2016
Novice
Listbox or Combobox population
 
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 Listbox or Combobox population Windows 10 Listbox or Combobox population Office 2016
Expert
 
Join Date: Apr 2014
Posts: 280
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, 2 views)
Reply With Quote
  #5  
Old 04-06-2019, 02:53 PM
wannaExcel wannaExcel is offline Listbox or Combobox population Windows 7 64bit Listbox or Combobox population Office 2016
Novice
Listbox or Combobox population
 
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
Listbox or Combobox population 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
Listbox or Combobox population 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 05:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft