I have an Excel application with some forms and some global variables.

For one of the forms I have a problem. If I close the form by pressing
the "x" in the right corner, all my global variables get cleared. If I
close it by using userform.hide then it's no problems.

There is no collision of variable names, and I don't have any macros in
the form so I can't understand what happens to my global variables.

My other forms does not have this problem.

I would very much appreciate any help in this matter!

Best Regards
Fredrik