How do you reinitialize a UserForm? (SOLVED)

[phantom1975]

I have a UserForm that has a MsgBox that appears upon exiting. If the MsgBox is vbYes, then the UserForm Unloads. If the MsgBox is vbNo, then I need to have the UserForm to start from scratch (reinitialize.) I figured I could just unload the UserForm and the reload it. Is there another way to do it?

_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-08-23 13:07

 

[Swamp Thing]

Instead of unload, you can use ".Hide" for temporarily exiting the form without losing its state.

 

[phantom1975]

Hide won't initialize the UserForm though. Unload isn't that tough, however, I was wondering what other approaches there might be.

 

[Ivan F Moala]

What routines have you got in the initialize
code of your userform ??

If you have routines that Initialize the userform then just call this

eg

Dim a
a = MsgBox("finsh", vbYesNo)
If a <> vbYes Then
UserForm_Initialize
Cancel = True
End If

 

[phantom1975]

I didn't realize that you could call an event-based procedures! My guess is that it will only call the procedure that is in the same module (unlike macros that are in the Project Modules.) Thanks for the simple piece of advice!