Userform.show = Catastrophic Failure

**mark.mba** · 05-14-2009, 10:11 PM

The app causes a Catastrophic Failure on some computers. At my office we all have the same computers but it does not fail on all of them. I have run it on old old laptops and it works fine.

On my computer it fails as soon at i enable Macros and it starts to load the form and it failed on another computer once. Most of the time it works. I have startup.show (startup is the name of my first form) in my workbook open and when it fails it debugs to that statment.

I can export the forms out of the project, delete them from the project and pull them back in and it works, but if i mod the forms any crash.

I know my code is a little sloppy but hopefully one of you guys can figure out what the deal is. It is driving me nuts.

Mark

**royUK** · 05-15-2009, 03:20 AM

You seem to have numerous identical userforms, even the code looks almost identical. If they do the same functions then you only need one & edit it so that it writes to specific sheets or whatever

Your code is difficult to follow, you declare variables randomly - it's best to put them at the top of the Procedure so they are easy to find.

You have Procedures in the WorkBook module that should be in a Standard Module.

If you know that the code is sloppy then make some effort to tidy it up.

Also, you don't need to select or activate the sheets

**mark.mba** · 05-15-2009, 08:29 AM

Yeah, I had to do this project quickly and the requirments changed as I built it. I will clean it up when I get time. I will try to ditch all the extra crap.

I still don't know if any of that could be causing the problem, though. I think it has something to do with me making copies of that same form, changing them for and renameing them. I read somewhere that there is a glitch in excel that bugs out when form names are changed like that.

I will work on it today and see what I come up with.

If anyone else has any ideas please post.

Mark