listbox vs filter

[ahmad123]

Hi folks,

I have a userform containing a listbox. In this listbox, theres data imported from a column ("vendor list") in a big spreadsheet.
What i need to do is to give the user the capability to filter the big spreadsheet by selecting lines in the listbox.

The listbox has to act like a filter for the column "vendor list". By filtering that column the user will see the rows corresponding to his selection n the big spreadsheet.


Can anybody help me with this. I assume its a small vba code.

Thanks to the Gurus

[JHCross]

I am not too certain about list boxes, but I do know that with a combo box (drop down box), vba has code section for combo box change. you could populate that combo box with the data you would need to filter the rows, and then just use the combobox.value tag to pull the value with which to filter your columns.

hope this helps!

[royUK]

Maybe this

FilterForm.zip

[tigeravatar]

ahmad123,

I know royUK beat me to it, but I made a sample book also

Hope this helps,
~tigeravatar

[ahmad123]

thx alot guys, i appreciate the help. But in my case i need to be able to choose more then one option from the listbox.

is it possible ???

thx again

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[ahmad123]

guys, in the attached file they're my file and my code behind.

In sheet2 u will find the button that has to create a listbox, but the problem is when i select options in this listbox, nothing happens !!!

And can u please modify the code so i will be able to make multi selections in the listbox ???

[royUK]

Which file?

[ahmad123]

this is the file

[ahmad123]

Can i get an input here please Roy ???

[royUK]

The Autofilter code can be adapted from my example, but I really can't see any need for what you want. Just use AutoFilter on the sheet.