Code after the "Unload Me" call?

[Robert Crandal]

On userforms, I typically call "Unload Me" when a
user presses the "Cancel" or "Okay" pushbuttons on
the form. I have a new situation where I might
need to run some code immediately AFTER
the "Unload Me" line in a userform module.

Does anyone know if it's wise or reliable to
put source code AFTER a call to "Unload Me"??
I get the impression that the Unload will clear the
userform and all associated userform code out
of memory, but I'm not sure.

I'd appreciate any advice. Thank you!

Robert

 

[Michael]

Hi Robert.

I'm not sure either. but as hint why not hiding your form rather than
unloading it:
Me.Hide
Your Code
Unload Me

Michi

 

[Mark Lincoln]

Can the code be placed before the Unload Me call? Otherwise, as
Michael said, hide the form until everything else is done.