Hello,
I have a problem statement. I need to filter data based on specific characteristics. So characteristics is in column 1 ( A24:A258). I need a method and code to add a separate activex control so as to filter the data based on these characteristics.
The problem I am getting is I have 3 objectives on the activex control:
1. Multiple values should be selected
2. We can type the characteristics to be selected as in combo box
3. The number of columns are dynamic. The keep changing depending on the data.
So I need a way to add this in my Excel sheet
Table is as such :
Characteristics date1. Date2. Date3. Date4. ........
The number of columns keep changing so I a code to handle that. Also the box(list or combo) must have option to select all the rows of characteristics.
Help!
Thank you for your time
I have a problem statement. I need to filter data based on specific characteristics. So characteristics is in column 1 ( A24:A258). I need a method and code to add a separate activex control so as to filter the data based on these characteristics.
The problem I am getting is I have 3 objectives on the activex control:
1. Multiple values should be selected
2. We can type the characteristics to be selected as in combo box
3. The number of columns are dynamic. The keep changing depending on the data.
So I need a way to add this in my Excel sheet
Table is as such :
Characteristics date1. Date2. Date3. Date4. ........
The number of columns keep changing so I a code to handle that. Also the box(list or combo) must have option to select all the rows of characteristics.
Help!
Thank you for your time
