Re: populate a list box with different data

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

<ndjxw17@xxxxxxxxxxx> wrote in message
news:1115918109.703260.130130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Re: Renamed EditBoxes keep reverting to their old names in UserFor
    ... but I think I could do with something to unload all loaded ... > userforms before I load the form i want to use. ... >> Regards, ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Worksheet Event
    ... Sub Workbook_SheetDeactivate ... man zur Bearbeitung einer Tabelle mehrere ... Userforms Modal gleichzeitig aktiviert und es soll halt so sein, ... Mit Unload Me bekomme ich allerdings einen Fehler wenn gerade ...
    (microsoft.public.de.excel)
  • Re: unload userform problem
    ... sub with an OnTime macro: ... Unload Me ... Application.OnTime Now, "SubToShowUF3" ... | I have some userforms and some code to get those userforms to work. ...
    (microsoft.public.excel.programming)
  • Re: there must be a better way - ensuring userforms are closed
    ... For Each f In UserForms ... Don Guillett ... > i have code that should unload a userform when it has finished running the ... > initialization code runs for each of the userforms whether or not they are ...
    (microsoft.public.excel.programming)
  • Re: Pop3 Problem
    ... > After reading some of the other posts I found a suggestion to unload ... Glad it's resolved - thanks for posting back (& thanks for searching/doing ...
    (microsoft.public.outlook)