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