Linked Combo's and List box

Stephen Byrom
Stephen Byrom used Ask the Experts™
on
Hi,
The other day, Kevin (zorvek) helped me to get unique values into a combobox as well as sorting and formatting it.
I then copied the code and played around with it, to try and populate a second combobox with unique values from data in the next column where the first combo box gets it's data, but I keep hitting a brick wall.

Basically, I am looking to end up with this;
combobox1 is filled with unique values from sheet "ShiptToy" column G.
I am trying to get combobox2 to also get unique values from sheet "ShiptToy" column F, based on combobox1's selection.
Then I would like ListBox1 to be filled with data from sheet "ShiptToy" columns B and D based on combobox2's selection.

I don't know whether it's possible, and it may be a bit too much to ask.
I have attached a trimmed-down version of the original workbook, and if I can get this sorted, I could then try and adapt any help to fit other procedures on other sheets.

As always, any help is much appreciated.
ComboLinx.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Warehouse/Shipping
Commented:
I'll do it with a table in the sheet.
Seams the easiest

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial