reset or empty a userform

[royboy531]

In my macro I have a userform to filter data. sometimes after I use the macro and then run it later the previously entered data will show back up in the userform. what can i put in my code to clear the data after it filters???
thanks

 

[royboy531]

I put it right before "userform1.hide" and ran it a few time and it seemed to work. when I would run it before It wouldn't always come back up with the info still in it. I did use "unload userform1".

 

[erik.van.geit]

my experience:
"Unload Me" is just fine when used within the userform code.
advantages of this syntax:
1.you can change the name of the userform without having to edit your code.
2.you know at a glance that it's the form itself and not another you are manipulating

depending of your goal, I think you could also use

       tbstartdate = ""
       Me.Hide

unloading has the advantage of clearing memory, but the userform will have to be loaded each time again, which can be rather annoying when there are much data to load

Private Sub btnFilter_Click() 
...
        .Range("a1:p1").AutoFilter Field:=1, Criteria1:=(">=" & startDate), _ 
            Operator:=xlAnd, Criteria2:=("<=" & startDate) 
       tbstartdate = ""
       Me.Hide
        Range("A1:P" & Cells(Rows.Count, "A").End(xlUp).Row).Copy 
...

kind regards,
Erik