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

--
When you lose your mind, you free your life.

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

--
When you lose your mind, you free your life.


"ben" wrote:

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

--
When you lose your mind, you free your life.

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


"ben" (remove this if mailing direct) wrote in message
...
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

--
When you lose your mind, you free your life.


"ben" wrote:

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

--
When you lose your mind, you free your life.

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

--
When you lose your mind, you free your life.


"RB Smissaert" wrote:

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


"ben" (remove this if mailing direct) wrote in message
...
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

--
When you lose your mind, you free your life.


"ben" wrote:

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

--
When you lose your mind, you free your life.