Always unload the form; exiting the sub will not release memory.

In a standard module...
Unload UserForm1
-or-
In the userform module...
Unload Me
--
Jim Cone
Portland, Oregon USA



"SteveM"
wrote in message
I've been away for VBA for awhile so generated a practice form to get
re-educated with the Controls on a new machine. However closing the
Form after testing presents an Out of Memory dialog box back at the
VBA design window. No other defect or app failure occurs.

I am running Excel 2007 with Vista 64 and 4GB RAM. I checked the
archives but found no explicit plea for this specific problem.

Any ideas?
Thanks Much,
Steve