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?
|