How to create a combo box in a cell depended on another combo box in a different cell usin

Hi everyone!

I’ve tried to search the forum for some other post that would have explained this same problem that I have, but couldn’t find any one.
I am very new to excel coding so I was wondering if some on could help me out with creating a vba cod for example these columns:

On the first sheet: Sheet 1 = Here comes the 3 combo boxes in different cells

Combobox1 -> ComboBox2 -> Combobox3

And in the first combobox1 I want for example my ranged list “cars” that I’ve created on sheet 2 and in combobox2 I want the cars brands for example “Honda” , “Mazda” and “Toyota” and in the 3 combobox I want the prices of each of the these brands and when I finally push on price for a brand I sends it to a different cell.

Is this very complicated to make, I really appreciated if someone could help me with the coding so I can learn from it in the future.
Thanks in advance!

I attached my combobox exel file if anyone wants to look at it.

Hi again everyone!

Now I have come this far on my combo boxes that are depending on each other, but now my problem is that when the last combo box puts its selection out in another cell. So what I would like it to really put there are the prices for the selection in the last combo box.
Here is the combo box attached as far as I am now.

(The drop boxes under the combo boxes are the same thing that I’ve tried to do with data validation lists but I didn’t like it coz it can’t handle when there are spaces in between the words or is there a way to do it without putting _ those between every word?)

Thanks! 