I have a VBA UserForm with 4 Combo boxes . These are dynamically populated by reading unique values from its corresponding column on a sheet and placing them in another sheet which the combo box reads.
The problem is that the user wants the following they select a value from ComboBox1. The remaining 3 combo boxes in effect requery to display choices only based on associations with the selection of ComboBox1.
The user then may select something from one of the other 3 Combo Boxes and would like the process to repeat itself and the remaining 2 in effect requery to choices associated with the first 2 selections.
I am trying to simply mimic what excel can do in the Auto filters but provide an interface that looks pretty.
I have done this many times in Access but was wondering how to approach this on a VBAS User Form in Excel. Thanks
The problem is that the user wants the following they select a value from ComboBox1. The remaining 3 combo boxes in effect requery to display choices only based on associations with the selection of ComboBox1.
The user then may select something from one of the other 3 Combo Boxes and would like the process to repeat itself and the remaining 2 in effect requery to choices associated with the first 2 selections.
I am trying to simply mimic what excel can do in the Auto filters but provide an interface that looks pretty.
I have done this many times in Access but was wondering how to approach this on a VBAS User Form in Excel. Thanks