Excel bug, variables reset?

[RB Smissaert]

Using Excel 2002 and 2003.
Have come across situations where a public variable that was initialized
before later for no obvious reason became uninitialized. I couldn't find any
reason at all for this in my code. I just made sure that when the variable
was needed
it got initialized again.
I just read in the book Excel 2002 VBA by Stephen Bullen et al. the
following text (in a bold textbox, page 297):

There have been (relatively rare) cases, in Excel 97, where bugs in Excel
have caused variables to reset.
It would be wise to expect that bugs could also exist in later versions.

Is this known to happen in later Excel versions?
Are there particular situation where this is more likely to happen?

Thanks for any insight in this.


RBS

 

[Dave Peterson]

You didn't end your code (by clicking on the Reset button in the VBE)?

And you don't have any END's in your code?
(not "end with" or "end if", but bare naked End's???)

Maybe one more look through the code would be in order.

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;169621&Product=ofw
OFF97: Displaying UserForm Designer Resets Global Variables

 

[RB Smissaert]

I thought it did happen without the VBE being open at all, but maybe I am
mistaken.
Will see.

RBS