Userforms: load, unload, show, hide

[tiredofit]

Would I be correct in saying that:

Userform.Show

automatically loads it (and displays it on the screen), whereas:

Unload Userform

will deactivate the userform (and therefore remove it from the screen)?

If I am correct, does it mean there's little use in:

Load Userform

and

Userform.Hide

Thanks

 

[diddi]

when a userform is unloaded, the variables are removed from memory and the form must be loaded or shown to reinitialise the variables and display the form. on the other hand a form can be hidden and shown without destruction of the variables (and hence their values)
a userform is also loaded if you assign a value to a control on the form from a subroutine not part of the form code. so you might assign the next invoice number to the form prior to it being shown from a main module and then show it to fill in the details

 

[tiredofit]

when a userform is unloaded, the variables are removed from memory and the form must be loaded or shown to reinitialise the variables and display the form. on the other hand a form can be hidden and shown without destruction of the variables (and hence their values)
a userform is also loaded if you assign a value to a control on the form from a subroutine not part of the form code. so you might assign the next invoice number to the form prior to it being shown from a main module and then show it to fill in the details

Thanks for your explanation.

 

[RoryA]

And here's why you shouldn't really be using either of those: UserForm1.Show

 

[tiredofit]

And here's why you shouldn't really be using either of those: UserForm1.Show

Thanks