Never seen this

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

Guest

Question, has anyone else experienced the following?



Have a project that uses several class modules and a couple of dozen
forms, Friday I added a form, that started RESETTING my project every time it
would unload. However I found out a most interesting fact. It will only Reset
my project if the VISUAL BASIC EDITOR IS OPEN. If it is closed everything
works peachy!! What did (do) I do!


Ben
 
Never mind that, now it's not being consistent at all, sometimes it seems to
reset the program other times it doesn't I even removed that userform and
added a whole other new one. a blank form resets the project, non blank
resets the project, if I remove that userform all other forms work great and
dandy, if i add one more, it will reset the project after it has appeared.
Confused and Frustrated,

Is there maybe a limit to the amount of forms Excel can handle in VBA?
Ben
 
There is no definite answer for this, but my impression is that if the
number of forms, normal modules and class modules together go above 100 you
could get
trouble.
Ideally the size of any individual module or form when in file form should
be below 64Kb, but I found that the above limit is more important.

Try running the code cleaner from AppsPro:

http://www.appspro.com/Utilities/CodeCleaner.htm

It may fix your problem.

RBS
 
: - )
Ironically enough I ran the code cleaner right before I read your reply to
my post. I have only 37 userforms, but the problem seemed to be a combination
of the Pcode leftover somewhere and the way I loaded the form. Thanks RB
Ben
 
Back
Top