Excel Cascading Combo Box Requery Like Auto Filter

Worsty

Board Regular
Joined
Jun 29, 2004
Messages
183
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,123,474
Messages
5,601,872
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top