crash changing const to public const
 

Could be a corrupted module.

Copy code to Notepad then back to a clean module. Delete the original module.

Regards
BrianB
--------------------------------------





Mike NG wrote in message ...
In my main Module 1 I had a const which I was trying to access from a
userform. Ran my application without complaining. Compiler complained,
so I changed const to Public Const. This resulted in

"excel has caused an error in VBE6.DLL. excel will now close down"

Happened to me two days running now! I sometimes get lazy and don't
compile, but have never had a problem. This only explanation for this
crash is the change of const to public const, unless there is some other
gunk in my code that would benefit from a clean.

Anyone else experienced this?