I was wondering if it is possible for a dropdownlist to have a "select case" feature?

My combobox'es value lists are based in refresh_dropdownlist which is on different sheet called "List"

If you're going to ask why I made this kind of sheet, it's because we always have new machines and lines so it will be easy for them to add new machine codes etc., without coding or calling me. And sheet list is linked to charts and formula for counting, "sum if" etc.

this is my list for combobox (

Note that it's Range().Value to set the ComboBox.List.