Ok, so to start, I already have code that will take the text entered into a ComboBox and apply it to filter in eXcel, once I exit that particular ComboBox, so this extra code I am needing will end up in the [Private Sub (ComboBoxName)_Exit(ByVal Cancel As MSForms.ReturnBoolean)]
However.... about 12 Filter headings, and each Filter has about 100-200 options a piece, which depending on how each filter is changed only certain options will show from each heading meaning that by selecting the first filter it can reduce Options from 100-200 to 50-100 whittling it down as filters are selected. And Side note about 281K Rows.
Example: (These are not actual options in eXcel this is just to represent)
If I were to select Item J016, then Promo List have only MO & MA as Options, and Type would only have SOCTY Option, but
if I were to select AAOY then Promo List would only have 1YR as an Option, and Type would have PERSONAL and INSTI. Bear in mind my actual lists have 100's of options under each heading and is updated regularly.
I need a way so when I change ComboBox for (Item) [At this point it sets filter on eXcel Sheet] then Combobox for (Promo) would only show avail options for that Item, and (Type) would only show options for that Type, and so on and so forth.
I don't need exact code just enough of a sample that I can work around for my needs. (leave plenty of comments about what each section of code does so I can remove/add/change more easily) If this is even possible.
Thanks!!
However.... about 12 Filter headings, and each Filter has about 100-200 options a piece, which depending on how each filter is changed only certain options will show from each heading meaning that by selecting the first filter it can reduce Options from 100-200 to 50-100 whittling it down as filters are selected. And Side note about 281K Rows.
Example: (These are not actual options in eXcel this is just to represent)
| Item | Promo | Type |
| J016 | 1YR | SOCTY |
| AAOY | MO | PERSONAL |
| THER | MA | INSTI |
If I were to select Item J016, then Promo List have only MO & MA as Options, and Type would only have SOCTY Option, but
if I were to select AAOY then Promo List would only have 1YR as an Option, and Type would have PERSONAL and INSTI. Bear in mind my actual lists have 100's of options under each heading and is updated regularly.
I need a way so when I change ComboBox for (Item) [At this point it sets filter on eXcel Sheet] then Combobox for (Promo) would only show avail options for that Item, and (Type) would only show options for that Type, and so on and so forth.
I don't need exact code just enough of a sample that I can work around for my needs. (leave plenty of comments about what each section of code does so I can remove/add/change more easily) If this is even possible.
Thanks!!
