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!
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!
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
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"pywhacket" wrote:
> 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!
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks