Filling 2 seperate listboxes with different values based on combobox choices

Hello all,
I have had great help from some who I believe are experts and have been teaching me as I learn vba. The last instance I had assistance with filling a listbox based on another listbox value chosen and that worked great! I have been asked to make a few changes to the userform to now have the listbox populated based on a combobox name chosen but it doesn't end there. The combobox has names in it and when a name is chosen the 1st listbox should populate with specific values associated to the name and the 2nd combobox should populate with values associated to the 1st listbox values. I managed to populate the combobox and the 1st listbox (not associated-having problems still) and the 2nd listbox fills correctly but only if I choose a value from 1st listbox which now needs to change to have those results populated the same but based on combobox chosen name.
I also need the values in each boxes to be not duplicated. Plus I need to find a way to populate the 3rd listbox with the 2nd listbox values from a different sheet (pivot table).

Example:
Combobox -choose Dir1 (column A)and 1st listbox fills with all values (not duplicated) from Column B and 2nd listbox fills with values (column D) associated to 1st listbox and 3rd listbox filled with values from pivot table (same values as listbox2 but different sheet-which houses pivot table summary) and all listbox results stemmed from combobox chosen value.

I think I explained that correctly and if not I can further explain or try to explain it better.

I am supplying a slimmed down version of the workbook should anyone want to see what I am trying to do

Please Login or Register  to view this content.

The initialize code above works fine.

The cmbMU code below works but doesn't associate to the correct cmbDirNames values

Please Login or Register  to view this content.

The following code below works when I click a value in lbxMU and fills the mbxTOG correctly but it needs to auto-populate based on cmbDirNames

Please Login or Register  to view this content.

The 3rd listbox I have not begun to try to build the code but do know I can use the getpivot code if have too but uncertain if that will work

Not certain what I am missing to make this work (with exception of pivot table results for listbox 3) that I haven't started yet since I am stuck at this point

Try this one for lbxMU and lbxTOG.

bakerman2 that works great! I never thought of using 2 array lists in the cmbDirNames. This is exactly what I am looking for and now I can work on the lbsummary! The 2 listboxes populating was throwing me for a loop and you solved it with ease! thank you very much!!!

Thanks for feedback and rep+.

1. What jindon ment by the sorting is that when you have f.i. Dir1 to Dir30 it'l sort like Dir1, Dir11,Dir12....Dir19,Dir2,Dir21 .....and so on.
In that case you need another sorting algorithm. The code jindon provided for sorting is a nice bonus but since you say that filling the combobox worked fine for you, it's a bit of overkill in this case.

2. As of retrieving results from a PT I've never tried that before so I should have to look into that.
I'm certainly not an expert on PT's but I suppose it's the combined results of a very large table. Maybe there's another approach possible ?

Is this how you wanted?

Please Login or Register  to view this content.