Reset dependant validation list when the previous validation list is changed.

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:

Please Login or Register  to view this content.

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

Try this...

Please Login or Register  to view this content.