Frequent Crashes with User Forms

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I'm using Excel 2007 and am writing something that utiizes user
forms. The program (Excel, not the macro) crashes frequently. I had
a similar problem a few years ago when using Excel 2000. Has anybody
else experienced this? Does anybody have any suggestions to resolve
it?

Thanks,
Randy
 
I also had this problem in Excel 2003. Instead of using the .Hide code, use
Unload. Unloading the forms after use seemed to eliminate the crashing
problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't save my file with macro 2
Excel crashes 9
PasteSpecial method of Range class failed Error 1004 8
refEdit and Excel crash 2
Maximum number of controls on a user form 5
Excel crashes 7
Excel 2002 and 2000 crash with Combobox on worksheet 1
Crash on ActiveWindow.Close 7

Back
Top