Help, Constantly Corrupted VBA Enabled Workbooks

[artiststevens]

Hello,
I keep having a problem with Excel VBA enabled workbooks becoming corrupted and stuck in the loop of Excel crashing and attempting to repair them. It has made VBA a nightmare to use especially after spending so much time updating and making changes. This happens whether I have a formula coded using the help of forum members or recording macros in Excel.

Any help with this and what I am doing wrong or can improve or fix would be greatly appreciated. I find this happens with almost every VBA workbook, to the point where I have to create backups constantly in order to preserve my work knowing that soon the workbook will become corrupted. These aren’t large workbooks either, probably about 5MB on average.

Once again, any help would be greatly appreciated. Thank you

[MarvinP]

Hi artist,

Make sure you have the latest version of Excel as some of the words may not be understood by earlier versions.
Hanging VBA code is a problem I have when things get stuck. I try to make my code fast by turning off things that might make your code work. Application.EnableEvents = False is one of the things that keeps me on my toes. If my code stops, due to an error, and I've disabled Events, when I go back and write more code and try it, I first need to turn those Events back on.

I've also noticed that before running new code, you should Debug->Compile first. If you try to run code that gets lost, this might be part of your problem.

Some code just takes longer to finish. If you use a lot of User Defined Functions they also might take a long time and look like a hang.

We'd need more info to really nail down what might be a better answer. I think a good debug site might help at: http://www.cpearson.com/Excel/DebuggingVBA.aspx

[artiststevens]

Hi Marvin,
Thank you very much for all of your help and advice. I'm going to look into all of this a report back. Thank you again.