I've got a couple of global variables in a public module. They are
instances of classes. On Workbook_Open, I run a public sub InitGlobals
which sets them good values.

Everything's fine so far. The instance variables are responsible for
busisness logic and communication with a a database. They also are the
event handlers for the controls on the sheets. Everything was running
swimmingly until this morning. I show a user form, run a sub based on
the user form, and when the sub ends, all of my globals are set to
Nothing. No idea why.

Anyone else experience anything similar? I've googled, and all I've
come up with is 'Convert it to an XLA and the problem goes away, but I
don't want to do that at this point.

Thanks

Jim

One thing to look for is to ensure that you are not using "End" as a stand
alone line of code something like this

if x=y then
End 'Problem here
end if

or

if x=y then End

end clears all globally declared varaibles...
--
HTH...

Jim Thomlinson


"fijimf" wrote:

I've got a couple of global variables in a public module. They are
instances of classes. On Workbook_Open, I run a public sub InitGlobals
which sets them good values.

Everything's fine so far. The instance variables are responsible for
busisness logic and communication with a a database. They also are the
event handlers for the controls on the sheets. Everything was running
swimmingly until this morning. I show a user form, run a sub based on
the user form, and when the sub ends, all of my globals are set to
Nothing. No idea why.

Anyone else experience anything similar? I've googled, and all I've
come up with is 'Convert it to an XLA and the problem goes away, but I
don't want to do that at this point.

Thanks

Jim