"Out of memory" error with userform

[Nav05]

I am creating a userform for my organization which has multipage controls on it, and many controls within each multipage. I had been working on getting the userform completed until I ran into an "Out of memory" error. This happens on a fresh restart of my computer and with no other programs running. I tried running the userform with and without the VBA code and the error still appears. The only thing I found was that if I deleted a certain number of multipage tabs, then the form will start running again, with or without the code. This has led me to think that perhaps too many controls are stopping the userform from running.

The most controls I've been able to run the userform successfully was 1809 (which I got from Me.Controls.Count). When I add the next page in (with about 30 controls), then the error appears. Any idea if there is a hard count on controls or how I can get around this error?

Thanks

 

[Dan_W]

I get this problem with my userforms regularly - it's intensely frustrating. My userforms rarely have more than 10 controls on them, so I'm not sure that's the reason.

As an aside - I've never heard of userforms with that many controls... Have you looked into creating these controls dynamically? (ie. at runtime)

 

[Nav05]

I get this problem with my userforms regularly - it's intensely frustrating. My userforms rarely have more than 10 controls on them, so I'm not sure that's the reason.

As an aside - I've never heard of userforms with that many controls... Have you looked into creating these controls dynamically? (ie. at runtime)

Thanks for your response. I haven't heard of creating the controls dynamically, but I'll look into it now. I know I probably took the long way around it, but my form is setup like this:

The user has a number of selections for a number of fields on the first page (tab). Based on what selections they make, they have certain forms on the following pages to fill out. A different selection would bring up a different form. So what I did was code each of the forms into it then only show the one related to the selection they made.