Hello all,
on a userform I have 9 multiselectextended listboxes (listbox3-listbox11) each with text values corresponding to values in columns A-I. What I would like to do is filter columns A-I based on whatever is selected in each listbox.

For example:

My data looks like this:

ColumnA country UNITED UNITED UNITED CANADA ITALY UNITED CANADA ITALY ITALY ColumnB attribute grape grape watermelon cherry lemon lemon lemon lemon lemon ...ColumnI scale 40000 30000 20000 20000 30000 20000 20000 20000 20000

and my listboxes list:

listbox3:
UNITED
CANADA
ITALY

listbox4:
grape
watermelon
cherry
lemon

...
listbox11:
40000
30000
20000


And so, on the userform, users can select any variety of things from any of these 11 listboxes. Based on those selections, I would like to click a button and have the spreadsheet filter based on the selectons.

For example: someone hi-lights UNITED from listbox1; grape and watermelon from listbox2; 40000, 30000 and 20000 from listbox11. My goal is to then click a button (which I already have in the userform as "CommandButton13") and have the datasheet filter so they are only showing results where: columnA = United AND (columnB=grape OR columnB=watermelon) AND (ColumnI=40000 OR ColumnI=30000 OR ColumnI=20000)

or, another way, as if I had selected filter and for column A only checked UNITED; column B checked only grape and watermelon; and column I checked all three: 20000, 30000 and 40000