question

SamirRanjanBhowmik-4401 avatar image
0 Votes"
SamirRanjanBhowmik-4401 asked

Making multiple inter dependent comboboxes in excel VBA

Hello,

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 link to the file with partial data of 3 months:

https://www.dropbox.com/scl/fi/ralzna42vow3tymiqgmu7/Comparaison-Copie.xlsm?dl=0&rlkey=i5n1dsjf6puxs5z8ihqen82t9

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

Thank you in advance

office-vba-devoffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers