Unique Cascading Dropdown VBA Multiple Lines For Inputs [More than 3 Combinations]

Hello all,


I found a thread which covers my need, however it is limited for 3 columns and I need at least 5.

In the thread he say it is difficult to set up it, so I would like to know if you could help me on that.

File attached

I have analyzed and modified the workbook you posted.
Try this version and see if it works for you.
I can help you understand it if you need me to.

Thanks a lot, it worked.

Did you improve any part of the code of just add the additional columns ? Thanks in advance

I added some comments and variable renames to try to understand the code. I also changed the values on a couple constants
that needed changing when adding columns to use for the data validation process. You should see that the constant sDataTables
has 5 values instead of 3. The constant sDataCols has 5 column ranges instead of three. I also changed the helper range to J1.

That was pretty much what needed to be done in the code.