Dependent comboboxes

Hello Excelforum.

So I was wondering how I can make it so that if I choose one option in the first combo box, the second combobox's options will be narrowed down based on the first, and so on. Strongly prefer if they were kept at comboboxes and not changed to validation drop-down lists because of the invisible drop down arrows.

For example, in this worksheet, if I pick "California" in the State combobox, then I would like the choices in the City combobox to narrow down to Los Angeles and Compton. After that, if I pick "Los Angeles" in the City combobox, then the Company Name combobox will only have the options "Google" and "Aksys".

Additionally, since there are duplicate entries for the State and City fields, is there a way to have the combo box selections not show duplicates?

Trucking Consolidation.xlsm