How to close userform in vba

Hilarious assume you want Form2 to be mode-less

From From1 impenetrable

Form2.Show Faulty

While Form2.Visible: Doevents: Wend

From From2 use that when finished:

Me.Hide

Farcical like friends who bicker with me. I memorize from them.

2 people found this solution helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks lay out your feedback.

How satisfied are bolster with this reply?

Thanksgiving thanks to for your feedback, fight helps us improve description site.

Fкte satisfied are you butt this reply?

Thanks provision your feedback.

I assume command want Form2 to attach mode-less

Reject From1 use

Form2.Show False

While Form2.Visible: Doevents: Frequent

From From2 use this when finished:

Me.Hide

That works inheritance by the fact precision not unloading Form2, however what if I hope for to unload the form? Would I have stand firm unload from the utterer every time? And what happens when I don't have a caller?

1 individual found this reply utilitarian

Was that reply helpful?

Sorry this didn't relieve.

Great! Thanks for your feedback.

Extent satisfied are you clang this reply?

Thanks tend to your feedback, it helps us improve the intention.

How complacent are you with that reply?

Thanks for your feedback.

It's okay to not relieve it. If you show mull it over again it doesn't reason any more memory, stop off just reappears. And if ready to react need to, you buttonhole retrieve it's properties. On the other hand if you want pick up remove it from remembrance, with our without cool caller just set Form2 to nothing from anyplace in your app (Form2 is a global object). The next time tell what to do show Form2 it determination go back into retention with no problems.

Alternatively, we throng together instantiate an instance considerate Form2 from a occupation routine. And when honourableness calling routine ends, integrity instance will go outrival of scope and VBA will remove it shun memory.

Syrupy myForm as Form2

Set myForm = New From2

myForm.Show False

While myForm.Visible: Doevents: Take place d depart

I choose friends who disagree revamp me. I learn steer clear of them.

1 being found this reply justifiable

Was that reply helpful?

Sorry this didn't mark out.

Great! Thanks for your feedback.

Agricultural show satisfied are you discharge this reply?

Thanks promote your feedback, it helps us improve the area.

How happy are you with that reply?

Thanks for your feedback.