Try using:
Unload Me
or (if this doesn't help)
UserForm_Activate() event instead of UserForm_Initialize() one.
Regards,
Maksim Sestic
www.geoinova.com
"Randy Richardson" wrote in message
news:40acd152$1_1@newsprd01...
> 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
>
> "Luis Alberto" wrote in message
> news:40ac515c$1_1@newsprd01...
> > 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?
> >
> > "Randy Richardson" escribió en el
> > mensaje news:40ab7a8a_1@newsprd01...
> > > 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
> > >
> > >
> >
> >
>
>
