How to Reset Dependent drop downs

Hi There,

I'm looking for some help on how to reset dropdowns that are dependent on a previous drop down. Please see my file attached. I would like to reset the type, product and length dropdowns on sheet 2 by use of a button on the sheet.
Please help.

Basic code:

Private Sub CommandButton1_Click()
    Range("B10").ClearContents
    Range("B7").ClearContents
    Range("B4").ClearContents
End Sub

Regards, TMS

Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save