I have 3 dropdown lists in cells B4,B5, and B6. B5 is dependent on B4 and B6 is dependent on B5. I need the dropdown list to reset itself if a change is made to the above list. I.E. if the selection in B4 is changed B5 and B6 should change to the first valid choice in the list based on the new value in B5. Additionally if B5 is changed then B6 should change to the first valid choice in the list based on the new value in B5.

I know I need to execute a worksheet change event but I have limited knowledge on VBA and am not sure how to accomplish this.

Thanks!