excel 2003 userform listbox to autofilter. Multiple criteria (beyond two)

Hi all

I am creating a userForm that allows multiple search criteria and filters the worksheet accordingly.
I have success with combobox, textbox, etc when only one selection is made, but i want to make multiple selections via a listbox.
Can this be done, i have the following code so far, when I choose multiple items in the list box it only returns one criteria.

I acknowledge that the 2003 version has a limit of two criteria and that the 'Operator:=xlFilterValues' doesn't work either.

Please Login or Register  to view this content.

A sample workbook would help your cause a great deal. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.

Remember to desensitize the data.

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

View Pic