• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Linked Combo's and List box

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
0
Stephen Byrom
Asked:
Stephen Byrom
1 Solution
 
Stephen ByromAuthor Commented:
I'll do it with a table in the sheet.
Seams the easiest
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now