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! |
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! |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com