Combobox and VBA Dependent List / Cascading List

[ninopolletta]

I need help creating a dashboard that contains 3 Comboboxs that then cascades through selection down to the resulting machines test results.

EX: Bulldozer > John Deere > 750K or Excavator > CAT > D264

My excel workbook is comprised of Multiple sheets for every type of construction machine. EX. Bulldozer Info, Excavator Info, Ex. Each sheet has a table with Brand, Model, Weight, Test Results etc. Im trying to create a dashboard that allows the person to select the machine type, brand, model, then the test results are shown below. I got the second combobox to provide the proper brand being dependent of the Machine, but there are still multiple duplicates. Last I have no idea how to connect the last combobox (Model) to be specific to the machine and brand to show the proper model in the vba code (Model Column in Each Sheet). It also has to allow for more machines in the other tables to be added without having to modify the code. When I get to the model im going to set a Vlookup so I know how to get the pass/fail information. I have linked a google photos with a couple photos of my setup and issues.


https://photos.app.goo.gl/8RDb4FgVaMd7oyVw8

 

[Reggie Perrin]

I'm not an expert at vba but I think it's a very complicated thing to do after looking around. The best solution may be to use a list box instead, I use them combined with an advanced filter (so multiple criteria can be used). Once an item is finally selected you can then do want you want with it.

An example of one I designed a while ago, it's a bit more complicated but a pic explains things better https://gyazo.com/cc71987abbda184cea40952187b599b3

Hope it may be of help