Need a list that allows multiple Selection

[mgao77]

Hello,

I have a list that uses an auto filter that I need to allow users to make multiple selections in.

For example, I need to be able to select the finance and HR departments from the list in order for the autofilter to automatically pull in required information (salary, employee id, performance, etc).

Can this be completed, and if so how? Does it require VBA?

Thanks in advance for any help!

[Olly]

Autofilters allow multiple selections...

Can you post your workbook, so we can see what you're trying to achieve?

[mgao77]

The auto filters are in cells b and C 3

Thanks!

[Olly]

Okay, that's not an autofilter, that's a data validation list. There's no way of multi-selecting values in a data validation list.

I'd suggest using listbox objects, with the MultiSelect property set to 'Multi'. Not sure what your code does (it's not in the attached file), but it would be easy enough to refer to the array of values multi-selected in the listbox(es), rather than in cells B3 & C3.

[mgao77]

Yikes.. It was a simple macro that used an auto to import data from the data sheet based off of the filters..

Now i have to figure out how to do that with list boxes since the advanced auto filter function doesnt work with list boxes