Clear multiple dependant dropdown lists

Hi

I am working on a spreadsheet excel that contains multiple dependent dropdown lists. I managed to find the VBA code that clears the contents of the second list if the first cell is changed...

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Column = 2 Then
If Target.Validation.Type = 3 Then
Application.EnableEvents = False
Target.Offset(0, 1).ClearContents
End If
End If

exitHandler:
Application.EnableEvents = True
Exit Sub

End Sub

This is working great for columns 2 and 3 of my spreadsheet,.

However, I have another dependant dropdown list in columns 9 and 11, and I need to apply the same logic to these (column 11 reverts to blank if column 9 is amended).

Please can someone help me? I've been searching the web for solutions all day and I'm getting nowhere!

BTW - I have zero experience of VBA!!

Thanks!

Try

Please Login or Register  to view this content.