Loading and Unloading Forms

[Glove303]

Despite having worked with VB for a reasonable amount of time, loading and unloading forms is something I have never truly grasped.

I currently do the following, which I feel is very inefficient, even though it does work.

Opening a form:

Unload Form
Load Form
Form.Show

Closing a form:

Form.Hide



This ensures that the form is always wiped clean before new data is put in it, and also avoids error messages when closing forms that they haven't been closed in the correct order.

However, unloading and loading a form to open it seems wasteful in terms of time.

If anyone could enlighten me on how I could improve this (probably very amateur) technique, I would be very grateful.

 

[bjurney]

To load a userform you only need

userform1.show

If the specified object isn't loaded when the Show method is invoked, Visual Basic automatically loads it.

to close it, you only need something like

Unload Me

When an object is unloaded, it's removed from memory and all memory associated with the object is reclaimed.

 

[Glove303]

I'm going to give this a go, cheers!

 

[Glove303]

This has worked perfectly. Much more efficient - thank you!