$20 USD - Userform to Display all column headers, show which have filters on, & edit

Hi there,

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.

http://www.ozgrid.com/forum/showthread.php?t=170363

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.

Thanks!

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

I'm sorry I forgot to include in my original post, that if possible, it would be nice to have the listbox be mouse-scrollable (mouse wheel). If this is too much additional work then not to worry.

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Hi SMC,

No problem on having to use the refresh button, I figured it was wishful thinking.

Can you tell me what the outcome would be if there was a date column present? I can live with the fact that I won't be able to perform actions on a date column that is being filtered, or that I want to add a filter to...I can just do these ones manually if required.

BUT, I wouldn't want the form to crash/error out if a date column was present...as most if not all of my data will have a date element to it.

If you can confirm that the form will still operate fine, and I will just lose functionality on any columns that are dates, then I have no issue, and approve the increase to $40USD.

Please let me know.

thanks,

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Hi SMC,

I am fine, please go ahead. I approve and will pay $40 USD.

Thanks!

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Thanks for the update. Its Thanksgiving weekeend here so probably no rush til Monday!

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Checking in....is this coming close to completion?

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Excellent, thanks for the update!

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Morning SMC,

Can I please get a status update and updated ETA on this when available?

Thanks,

Re: $20 USD - Userform to Display all column headers, show which have filters on, & e

Sorry, I didn't even notice that attachment when you posted originally.

Took a quick look and I'd say it looks great so far!