reset dependent combobox if 1st combobox is changed

[markda2000]

I am a complete novice when it comes to VBA but have been asked by employers to complete a project. I am stuck on several parts of it but the one that is giving me the most pain at this moment is dependent comboboxs.

I have two comboboxs set up where the second has a choice that changes dependant on the first. eg

1st combobox is a list of Car manufactures
2nd combobox is a list of model.

This works fine for me however if the user picks say "Ford" from combobox1 then "mustang" from combobox2, if they then go back to combox1 and pick "Chevrolet" at present the result is Chevrolet Mustang. How do I clear combobox2 when the user goes back to Combobox1 and changes the value?

Many thanks in advance.

 

[Norie]

Actually it was really a missing .Value after the last parentheses that was causing the problem.

Though the Value for the combobox isn't strictly needed, as you've found out.

 

[markda2000]

I will take your word for it,

These are very early days for me and my background has nothing to do with excel or any coding. Everything I am doing is basically I case of trial end error and now, your help.

I am aware constantly with this project that I am in deep water, and beyond my skills. But I will get there and will learn as I go along.

thanks again Norie