Interdependent Comboboxes

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    I have a userform with multiple comboboxes where the data are based on unique values from a table "DynamicPath_2" from a sheet called "MDB". I managed to get a working code from another forum member in another site but when I apply the code to my file it makes my excel stop functionning and give an error message as "excel has stopped working". I am quite new to VBA, and I am not able to find the bug which is creating this slowdown or crash.

    Could anyone help me resolve the problem by checking the code and if required even scrap the whole thing with a better piece of code?

    I am attaching the file with partial data of 3 months.

    Note: The table is quite large with more than 30000 rows of data

    Thank you in advance