"Out of Memory" Excel 2007 Vista 64

[SteveM]

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

 

[Jim Cone]

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" <[email protected]>
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

 

[SteveM]

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" <[email protected]>
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?

 

[Jim Cone]

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



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

 

[SteveM]

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

"SteveM" <[email protected]>
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