Userform with dynamic combo boxes and autofilters

**alfordtp** · 01-17-2014, 01:35 PM

Does anyone have any ideas/code to, on each combo box change, update the other combo boxes based on the selections? The combo boxes can be selected in any order.

I am guessing that each time a combo box is changed, all of the combo boxes would be checked to see if not null then filter data based on all the selections. when looping through the combo boxes on the form, how do you store those into variables that I can use for the advanced/autofilter?

It would be easier if the combo boxes had to be selected in a specific order, but it decreases the value of my form tremendously.

**mikeTRON** · 01-17-2014, 10:24 PM

I am not sure if this helps, but I like to use pivot tables linked together with slicers and use the activeX to control the slicer. I am not sure if it is the sexiest method...

**xladept** · 01-17-2014, 10:29 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic