I am coding a Userform. I want combo boxes that are tied to excel data from the workbook. I have that taken care of this easily.
I have coded the combo boxes to be conditional based on the previous selections in the other combo boxes. It is quite a bit of code. I cannot imagine Excel's code is this complex with its ability to endlessly filter a huge number of columns based on the other filters selected.
Does anyone know how to efficiently code conditional combo boxes for a large number of columns?
I have coded the combo boxes to be conditional based on the previous selections in the other combo boxes. It is quite a bit of code. I cannot imagine Excel's code is this complex with its ability to endlessly filter a huge number of columns based on the other filters selected.
Does anyone know how to efficiently code conditional combo boxes for a large number of columns?
