My Userform currently is used to apply auto filters to other sheets.
However, if I applied the filters, then close down excel, the userform will rese,t so I can't see what criteria I have filtered to.
Currently when closing the just the userform I've applied this code:
Which simply hides the Userform, when i attempt to close it, therefore when I open the Userform again i will be presented with my current filters.
But obviously if i exit out of excel my Userform resets.
I've attached an example spreadsheet
Bookmarks