compile error: out of memory
 

When I try an execute a userform I get the following error

Compile Error: Out of Memory

and the debugger takes me to the following code

Sub FullSummary()
UserForm12.Show vbModeless
End Sub

Any suggestions how to solve this problem??

Thanks

--
Message posted from http://www.ExcelForum.com

compile error: out of memory
 

how large is your userform?
how large is your code module?

but you will get problems if your exported codemodules get too big
(5k the limit? i cant remember the it sorry..)




else export the form and reimport it
or let this addin do it for you:
http://www.appspro.com/Downloads/CodeCleaner.exe

else maybe you played around with the forms DrawBuffer ?
reset to default of 32000.. or increase ?

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


bforster1 wrote :

When I try an execute a userform I get the following error

Compile Error: Out of Memory

and the debugger takes me to the following code

Sub FullSummary()
UserForm12.Show vbModeless
End Sub

Any suggestions how to solve this problem??

Thanks.


---
Message posted from http://www.ExcelForum.com/