Hi John,

As you may recall you sent your me your wb in early April to look at your
problem re memory leaks and crashes. You had several userforms, each loading
others something like this:

In UF1
Unload Me
immediately followed by lots of code, including calling various other proc's
followed by -
UF2.show

... and similar in the other userforms, each potentially being loaded &
unloaded multiple times, and going round in circles.

In some cases other forms were being loaded from proc's in normal modules
which in turn had been called directly after an Unload Me statement in a
form.

I tried to explain why each successive form unload / load would inevitably
lead to problems and advised, in particular, not to put more code after the
Unload Me and suggested and how to do it.

Without the benefit of seeing your project or a snippet of code, Tom
correctly guessed your problem, and went on to suggest both what you should
do and what you should not do. In essence, pretty much the same as I wrote
to you off-line some while ago.

Regards,
Peter T

wrote in message
oups.com...
I WAS NOT IGNORING THE SUGGESTION IT WAS THAT THE WAY I WAS DOING IT
WAS NOT EXACTLY HOW YOU STATED I WAS DOING IT, THE WAY I WAS DOING IT
WAS CONFIRMED AS OK BY YOU IN A PREVIOUS POSTING SO I WAS JUST SHOWING
YOU HOW I WAS LOADING/UNLOADING SO YOU COULD SEE IF THERE WAS ANOTHER
PROBLEM, THANKS FOR YOUR HELP