Date Filter Box Options

[kjnjanx]

Is there any way to keep the date filter box showing after selecting "OK"?

For instance, if I want to place filters on my data showing the first 3 months of the year - is there any way to keep that box visible so I know which range I am looking at?

I have attached the box I am referencing. I would like that to remain visible after selecting "OK", instead of going away completely.

Thanks!

[Keebellah]

With box, do you mean a userform?
Yes you can keep it visible set ShowModal = False so you can click on the sheet and continue
The screenshot is of another userform but just an idea

[kjnjanx]

Thank you for the reply!

The box I had attached was actually just from clicking on "Date Between" under filters. My ideal end goal is to have a start/end date box that will allow users to filter the data based on what they put in those boxes, but to remain visible for the user to know which dates they selected for their filters.

I would love to be able to have a Userform that includes the option for a Start and End date to then filter, but I'm not savvy enough to understand how that works.

[Keebellah]

I think that's possible, can you post a sample file and show there what you want the filter to do? I'll try and see then if I can do something for you

[kjnjanx]

Thank you for your help! I have attached a spreadsheet that is very paired down with 'dummy' data included. The "dates" I want to be able to filter by are in the Raw Data tab under the column "Lead Date".

[Keebellah]

With the 'filter form only be applied to the Raw Data tab? So only if this sheet is active the box should show?

[kjnjanx]

I actually would like to hide all of the tabs outside of the first one titled 'Dashboard'. That is where I would like the Userform with Start/End Dates to live, but it would be pulling from the "Lead Date" in the Raw Data tab, that then populates the pivot table/slicers. So essentially, a user would just input whatever data range they'd like on the dashboard tab, and it would filter accordingly. Hope this makes sense, sorry I didn't explain it very well!

[Keebellah]

First let's see if this works at all.
Due to my system's date settings the filter is not working well with the cell format
For now what this does is show the form the moment the Raw Data sheet is selected.
As long as you do not close the form it remains in place while you filter and do other things.
If by accident you close the form then just Right-click the column header Lead Date cell for it to reappear.
I will probably work if you invoke it from your dashboard but I don't know if Auofilter works on hidden tabs., you'll have to test that.
You will also have to look for a way to only list unique dates and sorted ascending but that's more code work.
I've attached the screen capture and the modified file
It's past midnight and I'm off to bed now.

[Keebellah]

Give this a test, it needs tweaking but it does the filtering, it's for you so apply it in the Dashboard
The selection form opens when DashBoard is activated or when the workbook is first opened.
Right-click C2 to show the form if you closed it by accident.
If there is a filter applied to Raw Data it will be shown in the selection.

[kjnjanx]

Thanks, Keebellah!
I appreciate all of the work you put into this. I think with a few tweaks, this should be able to allow for what I'm hoping to do!
Truly, I wouldn't have been able to do this without your expertise, so I am grateful.

[Keebellah]

Happy coding
I'm not so hot on slicers but I think you'll manage seen what you've done so far.
You know where to find me