"Out of Memory" Excel 2007 Vista 64
 

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

"Out of Memory" Excel 2007 Vista 64
 

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

"Out of Memory" Excel 2007 Vista 64
 

On Apr 8, 11:25*am, "Jim Cone" wrote:
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

Thanks Jim. I did. And closed all other active apps. But it didn't
work.

Any other ideas?

"Out of Memory" Excel 2007 Vista 64
 

Restart Excel and then see if unloading the form makes a difference.
No other ideas except... xl2003
--
Jim Cone
Portland, Oregon USA



"SteveM"
wrote in message
Thanks Jim. I did. And closed all other active apps.
But it didn't work. Any other ideas?

"Out of Memory" Excel 2007 Vista 64
 

On Apr 8, 11:54*am, "Jim Cone" wrote:
Restart Excel and then see if unloading the form makes a difference.
No other ideas except... xl2003
--
Jim Cone
Portland, Oregon *USA

"SteveM"
wrote in message
Thanks Jim. *I did. *And closed all other active apps. *
But it didn't work. *Any other ideas?

Hey, simply sublime...

It worked!

Thanks,

SteveM