Extracting unique values from filtered column to array

Hi all

I have a need to
1. Filter a sheet,
2. Extract unique values from a column, and
3. Populate a listbox (on another sheet) with the unique values.

I can filter using VBA, but I don't have the foggiest on how to extract unique values from a filtered column into an array.
The filter

Please Login or Register  to view this content.

With this, the idea is that I can use a listbox(1) to select the items I want to filter. This will filter the sheet. Then I collect the unique values from another column which I can then use to populate listbox(2)

then listbox(3),(4)... and so on.

It should be noted that I am using this code to extract unique items, but I don't now how to make it work with a filtered list

Please Login or Register  to view this content.

I'm sorry I can't share my sheet because that would be pointless, and because it's too big and contains company data.

Can anybody suggest some code that will help with this?

Cheers

I'm sorry I can't share my sheet because that would be pointless

The idea is to set up a sample file that depicts your actual file setup...
This way one can immediately see what your scenario is and assist in creating the perfect code snippet...

Pointless to try and offer a solution as there could be multiple solutions posted and none would benefit you as they are not written for your file setup...
Code is tailor made...

See here for a few ideas...