big goose egg. Bupkus. Nada. There is NO memory advantage to using .Hide. Which of course makes sense, as memory is still allocated.
True, no argument, I was only going by what Bill Gates says:
Unload Statement
Removes an object from memory.
Syntax
Unload object
The required
object placeholder represents an
object expression that evaluates to an object in the Applies To list.
Remarks
When an object is unloaded, it's removed from memory and
all memory associated with the object is reclaimed. Until it is placed in memory again using the
Load statement, a user can't interact with an object, and the object can't be manipulated programmatically.
BTW: do you know of a way to identify ONLY the GUI resources involved with a userform. Remember the resources you are testing with your code are system resources, not specifically GUI resources
Really wish I did. I'd really like to find out some what to see just how much the application is using
So if I'm reading you and Chairman Bill right, I could just use .Show and Unload if I wanted to, correct????
Paul