Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Releasing all Userforms in memory
VBA provides methods to Hide (which keeps it in memory and
programmatically available) and Unload (which supposedly removes all traces of the form until it's loaded again) any given form. But is there a way to unload any and all forms that are presently in memory? Thanks for any input. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Releasing all Userforms in memory
Sub Tester1()
Dim frm As UserForm Dim frm1 As UserForm1 Dim frm2 As UserForm1 Dim frm3 As UserForm1 Set frm1 = New UserForm1 Set frm2 = New UserForm1 Set frm3 = New UserForm1 Debug.Print UserForms.Count For Each frm In UserForms Unload frm Next Debug.Print UserForms.Count End Sub 3 0 is the result. -- Regards, Tom Ogilvy "Rich" wrote in message ... VBA provides methods to Hide (which keeps it in memory and programmatically available) and Unload (which supposedly removes all traces of the form until it's loaded again) any given form. But is there a way to unload any and all forms that are presently in memory? Thanks for any input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Releasing arrays? | Excel Discussion (Misc queries) | |||
UserForms | Excel Programming | |||
Question about releasing memory | Excel Programming | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |