Comma delimited cells multiselect listbox filter

I have a worksheet that has a column with comma separated values. which gets broken up and added to a multiselect listbox as individual items. these items are categories so there are repeated items and such. ie.

cells:
a1 = cat, dog, mouse
a2 cat, dog
a3 mouse
a4 dog mouse

listbox: all
cat
dog
mouse

what i'm trying to do is have it hide all rows except the rows which contain the items selected, but it is only showing the first item selected from the list instead of all of them and only if it isn't one of the cells that has more than one item in it.

any help would be much appreciated.

Thanks,

Chris

Please Login or Register  to view this content.

Please Login or Register  to view this content.