Microsoft Office Forums

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, 6 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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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's Avatar
p45cal p45cal is offline Listbox or Combobox population Windows 10 Listbox or Combobox population Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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, 7 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 PM.


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