Hello all,
In the attached workbook I have four hierarchical drop down lists named Region, Zone, District, and BAC, with Zone, District, and BAC all dependent on the selection in the previous field. I am looking for the VBA to clear any dependent list selections when a different superior selection has been made.
E.g.: if there are selections made in all four lists, and then Region is changed, the bottom three are cleared.
Or, if there are selections made in all four lists, and then Zone is changed, the bottom two are cleared and Region remains.
Or, if there are selections made in all four lists, and then District is changed, just BAC is cleared and Region and Zone remain.
Any help would be greatly appreciated!
Bookmarks