It could probably be done, but you are duplicating what is already done by
the built in dropdowns. It would also take a lot of code if you want to
reproduce their ability to be progressively restrictive. Also, the custom
feature of the builtin filter offers a lot more flexibility - again, that
would tak a lot of work to duplicate. Where is the advantage to having a
popup?

--
Regards,
Tom Ogilvy

"mnvkngs" wrote in message
...
I am trying to set up a macro that will initiate a pop up box that has all
of
my column headers in it. Then I can go through the list and select which
filters I use on any or all of the columns. Once I pick all the criteria
I
want the macro runs and returns my data for all rows that match the
filters.
Essetially its the same as going through column by column and selecting
different filters until I get down to a small list.

eg.
column 1 (Name), Column 2 (State), Column 3 (vehicle type), Column 4
(vehicle make) ...

The popup would prompt me to select filters and I could pick Truck (col 3)
and Toyota (col 4). Or choose state and toyota (Etc etc etc). Then have
the
correct autofilters automatically run.

Thanks in advance for any suggestions.