SilencioDubueno
New Member
- Joined
- May 26, 2022
- Messages
- 4
- Office Version
- 365
- 2021
- Platform
- Windows
Hello all! I'm attempting at making a userform that has certain buttons/conditions that will close and reopen the blank form as needed. The code I've always used for it is by having a sub that does it.
I am expecting it to close the userform and then reopen it. Whenever this code is run, it will shut down the userform and seemingly stop/terminate the code. I have tried hardcoding the Unload/show section into the various sections within the userform code, as well as setting it into a module outside the userform, and having the sections call it instead. Nothing seems to work.
Any help is greatly appreciated!
VBA Code:
Sub Reset()
Unload UserForm
UserForm.Show
End Sub
I am expecting it to close the userform and then reopen it. Whenever this code is run, it will shut down the userform and seemingly stop/terminate the code. I have tried hardcoding the Unload/show section into the various sections within the userform code, as well as setting it into a module outside the userform, and having the sections call it instead. Nothing seems to work.
Any help is greatly appreciated!