help!! reset a form

[Guest]

How do you reset a form after macros have run? I have a macro that deletes
all lines that have a 0 in column C after data has been pulled in from other
sheets. I need to add a button that will restore the form to it's original
state.

Thanks!

 

[Guest]

If you mean useform, then you need to put in code that resets each control
individually.

Easier it to unload the form and then show it again. Don't do that from the
code in the form itself however. handle that in the code that shows the
form.

Public bshowform as boolean

Sub Main()
bshowform = True
do while bshowform
userform1.show
Loop
End Sub

in the userform code

Private Sub cmdClose_click()
bShowForm = False
unload me
End Sub

Private Sub cmdExecute_click()
' code that works on your sheet
bshowform = True
unload me
End Sub