Reset two MUTUALLY dependent drop down lists in Excel while avoiding any fatal loop crash

I'm preparing an Excel report schedule that contains some filters so the user can restrict the scope they want to see, and two of those filters are YEAR and MONTH, as the couple screen shots below:

Year_Drop_Down.png

Month_Drop_Down.png

I wrote a named formula into Data Validation so every time a user selects a specific year on B3, the MONTH drop down below will show only those months related to that particular year. Conversely, every time a user selects a specific month on B4, the YEAR drop down above will show only that year related to that particular month that was selected.

And then I wrote that basic VBA code below so that every time the YEAR drop down on B3 is erased, if there's anything already selected on the MONTH drop down on B4 it will get automatically reset as well, in order to avoid inconsistencies of what is selected between the two cells (i.e.: 2021 is selected in YEAR and Mar/2020 is already selected in MONTH, which would generate a report error).

Please Login or Register  to view this content.

However, I also need the other way around to happen too: reset what's on the YEAR filter in B3 every time an user erases what's on the MONTH filter in B4.

I tried tweaking the above code to make that happen, but when I try to run it I either get a VBA code error or a fatal loop that ends up crashing and closing Excel.

Is it possible to achieve what I want? And if so, what would be the best coding route? I'm really a newbie with VBA, so.....

Thanks in advance

P.S.:
I also posted the same question on a couple other discussion forums:
https://stackoverflow.com/questions/...ng-a-fatal-loo
https://techcommunity.microsoft.com/...le/m-p/2744523

Try;

Please Login or Register  to view this content.

Thank you!

No problems.