excel errors

[john.9.williams]

Hi,

I have written alot of basic excel programs using VBA, i generally get
the below message inconsistently when i am using them

"Excel.exe has generated errorsand it will be closed by windows you
need to restart the program an error log is being created"

Can anyone advise how i can solve this, it does only seem to happen on
programs that use userforms, i thought it was due to the fact that i
was not unloading the forms before i shut excel down, but i am now
doing this. help

Johny5

 

[Tom Ogilvy]

That is just a general error message telling you you have caused a critical
error. I would think there are an endless list of things that could cause
this, especially if VBA enters the picture.

Try running Rob Bovey's free code cleaner utility on your workbook (if it is
a single workbook that is frequently causing the problem).

http://www.appspro.com

go to the downloads section.