When moving the objects, etc., resulted in something working, you were
reinforced for believing the extra forms (or whatever) did the trick. But
maybe not. There were other things, no doubt, you also had to change when
moving these things. So check carefully the code you changed. You may even
have smiply corrected a typo when you did that.

After many mucho years of programming experience, I've seen my share of "out
of memory" and "hung" programs. 99.99% of the time, it was an unintended
infinite loop that just kept cramming something into something else -- or
kept declaring something and declaring it again.

Either way, you will likely find the culprit (and the "limit" if in fact
that is the issue) by putting in breakpoints (or MsgBoxes or debug.Print
commands,...)-- especially in _Event Subs.

I hope this might help in some way.

Jim
-----------------

"IT_roofer" wrote:

Does anyone know if there is a limit to the number of Control Objects someone
can have on a UserForm?

I ran into an "Out of memory (Error 7)" error today after adding in a few
Labels and Textboxes to a project I'm working on. I added in my objects and
went to edit the code behind them and it wouldn't let me add code. I shuffled
my code from the userform into different modules in an effort to eliminate
the number of lines of code and that wasn't working. I finally moved a few
frames that contained a bunch of objects into new userforms and that did the
trick.

Any ideas?