Userform to Display all column headers, show which ones are currently being filtered.

    Hi there,


    I'm wondering if it would be possible to have a macro that calls a userform to display the column headers of the current sheet, show which if any of these are currently being filtered, and be able to apply new filters, adjust current filters, or clear current filters.


    I find myself working with large amounts of data with plenty of columns, so it gets somewhat tedious to have to scroll through all the columns to apply certain filters, or make sure certain filters are cleared etc.


    Any insight would be appreciated.


    Thanks,

    Re: Userform to Display all column headers, show which ones are currently being filte


    here are some usfull autofilter codes:


    Re: Userform to Display all column headers, show which ones are currently being filte


    Please ignore the first If statement it actualy does not work as indicated. all other should be ok though

    Re: Userform to Display all column headers, show which ones are currently being filte


    Can you give us a bit more information.


    Do you only want to show the headers, how do you want to show them - in Textboxes or what?

    Re: Userform to Display all column headers, show which ones are currently being filte


    What I am looking for as an end product would be:


    Column 1 of the userform to display all of the headers, 1 header per row
    Column 2 would show the active filter criteria on the corresponding header, if one is present, else just leave blank


    And then from a functionality stand point allow the user to either clear or edit current filters, apply new filters, or clear all.

    Re: Userform to Display all column headers, show which ones are currently being filte


    Any bites or insight on this yet?

    Re: Userform to Display all column headers, show which ones are currently being filte


    I've attached a sample workbook so you can see the userform etc.


    So far I have been able to return a listbox with the column letter, the column header, and what criteria are active for each.


    What I wanted was for it to stay visible, so i show it modeless, however, to get it to update if any of the criteria changes or new filters are added, i had to add a refresh button to hide and show the userform. I would prefer it to just update automatically, but can't figure out how.


    Also, as for the final part of my question which was to be able to apply, edit, or clear filters I have not even the slightest idea to get there :(!


    forum.ozgrid.com/index.php?attachment/48841/

    Re: Userform to Display all column headers, show which ones are currently being filte


    Looks like maybe this was harder than I thought?

    Re: Userform to Display all column headers, show which ones are currently being filte


    There's no event that I can think of when the sheet's filter is changed

    Re: Userform to Display all column headers, show which ones are currently being filte


    Would you have an idea of how to at least add the functionality to be able to click on one of the entries in the userform and have the ability to edit/create/clear filter criteria for that range?

    Re: Userform to Display all column headers, show which ones are currently being filte


    What exactly is the purpose of the form? In some of my databases I actually have a form that filters the data & displays the filtered data in the form

    Re: Userform to Display all column headers, show which ones are currently being filte


    [ATTACH=CONFIG]48868[/ATTACH]


    Here's an example form that controls Filtering

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login