Apply Filter Based on Mutliple Item Selection in Data Validation List

Dear All,

I created a data validation list to select multiple items. These items get accumulated with a comma (like Item1, Item2, etc..) in the adjacent.

I have written a small VB code to apply autofilter on a data sheet based on these filter criteria. Below is the code.

Please Login or Register  to view this content.

This works fine it is a single selection. But does not work with multi-filtering with commas.

Please shed some light on how I can get around this. Bottomline, I want to autofilter items based on multiple options selected.

Thanks.