I have created an addin in excel 2002. I load the addin through
toolsaddinsbrowse. It then puts a menu item in the tools menu. I click on
the addin and the userform I created comes up and I hit the ok button on my
userform. It runs for about 30 seconds and then gives me an error. I
noticed I had a GoTo statement between a With and End With. So I cut
everything in the GoTo staement and put it outside the With staement and ran
it again. It ran correctly so I saved the addin file. I then closed excel
and tried to run it again. It did not give me an error message it just quit
running. So I went to the VBE and made sure the code was correct. It was
correct. So I then ran the addin again and it ran fine. It seems like after
a bad run the next one is a good run. Any suggestions to what is causing
this?

Any help is appreciated

and made sure the code was correct. It was correct. ....

Not quite.
If you post that code we may have a chance to see what is wrong.

RBS

"sc" wrote in message
...
I have created an addin in excel 2002. I load the addin through
toolsaddinsbrowse. It then puts a menu item in the tools menu. I click
on
the addin and the userform I created comes up and I hit the ok button on
my
userform. It runs for about 30 seconds and then gives me an error. I
noticed I had a GoTo statement between a With and End With. So I cut
everything in the GoTo staement and put it outside the With staement and
ran
it again. It ran correctly so I saved the addin file. I then closed
excel
and tried to run it again. It did not give me an error message it just
quit
running. So I went to the VBE and made sure the code was correct. It was
correct. So I then ran the addin again and it ran fine. It seems like
after
a bad run the next one is a good run. Any suggestions to what is causing
this?

Any help is appreciated