Dynamic list based on Combobox value

[NDMDRB]

Hi,

I have a Workbook with many Sheets and a lot of lists using "Dynamic Named Ranges"
Also a "User Form" with a lot of "Commands, Combo Boxes and Text Boxes"
Here is a small sample of my Workbook
EMV Master File - Test.xlsm

If I need to add a new equipment, if the "Type" is already exist then the "Code" will be offset(,-2)
And the same situation when I choose the "Model" it will fill the "Make" automatic if exist, else I will add it manually

In my code, for example, if I need to add a new "Wheel Loader" or a new "Grader" or whatever, the "Model" list will be the same for all
What I need is, once I choose a "Type", (Ex: Grader) I need the "Model" list to be (14H, GD755)…

Many thanks in advanced

 

[Jeffrey Mahoney]

Turn your list into an Excel table. Create a named range that references that Table Column. Use that named range in the data validation. Now that you have selected your equipment, using lookups can get you the other details from the table.

 

[NDMDRB]

Turn your list into an Excel table. Create a named range that references that Table Column. Use that named range in the data validation. Now that you have selected your equipment, using lookups can get you the other details from the table.

Thank you Jeff,

I'm not sure if this is not what I'm looking for or I didn't get it

Here is what I got from your solution:
If I chose (lets say "Grader" then the "Model" will be "14H") looked up the first Grader Model, isn't it?

But I need a List in the "Model" ComboBox contains all the Grader's Models ( 14H, GD755 .....)