Hello! This is my first post on this forum so I hope that it'll be comprehensible.

Quite recently, I've made a spreadsheet with four dependant validation lists (the lists are in the following cells: A2, B2, C2, D2 and the content of B2 depends on A2, the content of C2 depends on B2, and the content of D2 depends on C2 ). However, I've encoutered a quite common problem- after changing the selection in A2, the one in B2 still corresponds to the previous selection in A2, and so on.

Before posting here, I did some research and managed to find something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A2") Then Range("B2").ClearContents
End Sub
This manages to clear B2, when I change A2, but, due to my very limited knowledge of VBA (to say the least), I can't really adapt it to my problem.

I'd be really grateful for any help with this. If any addtional information is required, I'd be happy to provide some more. I'd rather not enclose my excel file, because it's in Polish.

Cheers,
Mike