Userform does not load

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform load problem...please help! 3
Userform to load when Workbook is opened 4
Worksheet appears briefly before UserForm opens 4
Userform with 1024+ textboxes 13
Userform textbox string to header causes unwanted double spacing 4
UserForm loaded twice in VBA Project Explorer 2
Maximum Controls on UserForms 3
Question about modal userform..... 2

Back
Top