Creating Dependent Searchable Lists (List Box Dependent on Combo Box)

[antman2988]

Hi All,

I am not entirely sure how I should go about accomplishing this because I believe there are a few ways to do this.

I have a list of data similar to below:

0582 051
0582 954
0582 725
1275 654
1275 777
5290 936
5290 003
5290 051
5290 923
5290 000

Basically, I want to create dependent list boxes, combo boxes, or drop down lists. I feel as though combo boxes would be the best because the first box is going to be populated with over a thousand codes (first column) so it would be best if the codes were searchable. Depending on the choice selected in the first box, only 20 or less options will appear as choices in the second box. However, the second box needs to allow for multiple selections. A list box would probably be the best option for this. How could I create a list box dependent on a combo based on the setup of the data above?

In addition, would the second box populate another cell with its data? For example, all of the codes that are selected in the second box should appear in the cell next to it.

If there is any more information I can provide, please let me know.

Any help is appreciated!

Thanks,
Anthony Smith

 

[antman2988]

Here is the link to the example file. https://www.dropbox.com/s/mrpc5wd2jwk2hh9/Project Code Drop-Down Menu.xlsm?dl=0

 

[MickG]

Try this:-
NB:- I've add a few duplicates in second sheet column 2, in case you want a selection from Combobox2.
https://app.box.com/s/p3y6vikdr85in0rg3bfbslqcfbay0o40

 

[antman2988]

I apologize for being ignorant, but what are the other command buttons doing?
Also, sorry for a late response as I've been busy with other assignments.

Thank you for all of the help.

 

[MickG]

You're welcome
I think the other Commandbuttons in the second sheet where just for a few tests, I think everything you want is on the first sheet.

 

[antman2988]

I know it's been about a week, but I was updating the data on the second sheet, and I kept getting a mismatch error with the new data. The issue seemed to be with the data being in a text format. I fixed this by converting it back to a general format. Unfortunately, this takes away the leading zero (I didn't have a code with a leading zero in my previous example) so I used a custom format instead to keep the leading zero. This doesn't give me an error, however, the leading zero doesn't appear in the combobox. How do I adjust the code to maintain the leading zero? Also, an error appears when trying to type into the combo box. Is it possible to make it searchable?

Thanks again!

 

[MickG]

Try this :-
https://app.box.com/s/u3lxto31ibw9p15tj04f3ou7l6c8uzrz