Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help!! reset a form
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help!! reset a form
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Reset data input form | Excel Worksheet Functions | |||
How do I reset the tab key? | Excel Discussion (Misc queries) | |||
How do I reset the tab order in a form | Excel Worksheet Functions | |||
how to reset form | Excel Worksheet Functions | |||
checkbox on form reset from checkbox on sheet | Excel Programming |