Two issues:

I'am designing couple of userforms in excel 2007 which uses existing data of excel sheet. Each userform has multiple combo boxes (to filter out the results) & listbox (to show results).

Issue-1: I have been managed to show results in listbox using one combo box (Primary one) using below code of Chip Pearson. all i want now is to apply further filters using other combo boxes values on available listbox results only. (means if i use 2nd combo box value selection & if that value exist in listbox search results then it should filter listbox results basis of 1st & 2nd combo box values & go on with other combo box as well. this will go on till 10 combo boxes)

Issue-2: Need help to show Listbox headers. I know it will be done using rowsource but doesn't know how to implement here in mentioned code.

Any help would be highly appreciated.

Thanks in advance !!!

Please Login or Register  to view this content.