Dynamic list based on Combobox value

NDMDRB

Board Regular
Joined
Jun 20, 2016
Messages
158
Office Version
  1. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jun 20, 2016
Messages
158
Office Version
  1. 2016
Platform
  1. Windows
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 .....)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,078
Messages
5,622,553
Members
415,907
Latest member
Walters87

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top