View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Load and Unload Form commands

I personally have never used Load since a Show will do a Load if needed. I
suppose if you had a long initialization routine you might do a separate
Load so the eventual Show is not delayed.

Unload clears the form from memory, so besides freeing the memory, it would
cause the form to re-initialize the next time it is shown. If you just do a
Hide the form will retain its current control values at the next Show.

--
Jim Rech
Excel MVP
"R Avery" wrote in message
...
| When are these commands needed? I never seem to need to load or unload
| a form in my code; all forms seem to be loaded all the time, and never
| unload even after i use the unload frmMYFORM function. What do they do?