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