UserForm_initialize again on Unload

When I unload my form, function UserForm_initialize begins to run
automatically. There is no specific instruction to make this happen. I
would rather it not happen. Does anyone know of a circumstance under which
this might happen? When I make a small program and test it out it does not
happen, but in my very large project it does.

Thanks,

-Randy

 

Hello Randy,

For me some times it occurs because, after unload it, I make a call to one
or more objects in that user_form (for example, MyVar =
User_Form.TextBox1.Text). Could it be what is happening to you?

 

Thanks for your reply, Luis.

No, after I close the form I don't make any more calls to the objects in the
form. It just goes to UserForm_initialize right after the call to
UserForm.Unload.

Fortunately, this does not do any real damage.

-Randy

 

Try using:

Unload Me

or (if this doesn't help)

UserForm_Activate() event instead of UserForm_Initialize() one.

Regards,
Maksim Sestic
www.geoinova.com