Thread: [SOLVED] Clear Dependent Drop Down Lists

I have two dependent drop down lists in B11 and C11. I am trying to clear C11 (Learning Marks) whenever B11 (Subject) changes.

I've also tried the following code on a WorksheetSelection_Change event to no avail....CHGLIST.xlsm

Any help is appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("B11")) Is Nothing Then Exit Sub
    Range("c11").ClearContents 
End Sub

Sorry for not complying with the posting rules - won't happen again!
Ambassador777

The macro you posted above is correct and works in your workbook.

The macro in the sample workbook is NOT that macro and it will not work. Use the macro you posted above.