So I originally posted this on the free section of the site but haven't gotten any bites so trying this out. Essentially what I am looking for is a monitoring window that will show me all of my columns, which have filters, and allow me to edit, remove, create filters directly from the userform.
In the link provided I provided a sample workbook with what I have come up with so far. Which is the ability to return the column headers, and show any active filter criteria for each column.
Please note that I am in no way set on the current code, or use of listbox etc. I just know that what I have is roughly the visual output that I want, so if this can be done more efficiently in a different manner then I have no issue.
What is left to be determined/done:
1) I want the userform to be modeless, so that I can leave it up while I am working. Issue is if changes are made to any filter criteria or new filters are applied, the listbox doesn't update. The only way I have been able to get around this for now is to put a refresh button which hides, then shows the userform again. I would like this userform ideally to auto-update if/when there are any changes made.
2) Add the functionality so if the user selects one of the column headings, they have the option to a) edit the current filter (change/remove/add criteria), b) add new filters to columns that are not currently being filtered, c) ability to clear filters for specific columns, d) button to clear all filters
Any further info/clarification required please let me know.