ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform does not load (https://www.excelbanter.com/excel-programming/387356-userform-does-not-load.html)

Ozgur Pars[_2_]

Userform does not load
 
Hi,
I have a userform with couple of hundreds textboxes,spinbuttons and stuff...
I recently added a few more and I get this error when I try to show the form.

Compile Error - Out of Memory

Anyway can I get around this one?

Thank you,
Ozgur

Allen Lance

Userform does not load
 
Hi Ozgur,

I think it's time to downsize your userform. If you have that many
objects on one form with no problems and you start running out of
memory after adding a few more you probably crossed the limit.
Consider tying two userforms together so that when the user is done
filling in the first one it closes and opens the second one.

HTH

Allen






All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com