Unload UserForm Runs Initialize

[McNultyK]

During execution of one of my applications, the user can go to a particular UserForm and change the units. For example, bar to psi. In order for the correct units (psi) to be displayed, all userforms that have pressure unit lables are unloaded (rather than hidden) so that when the userform is opened it will run the Initialize sub which changes the labels to "psi" for all the pressure inputs. The problem is that when the "Unload UserForm1" code is executed, it sometimes runs the Initialize sub before the UserForm is unloaded. I want the Initialize sub to always run when the UserForm is opened, not when it is closed. Is there a way to do this?

[romperstomper]

That should only happen if the form had already been unloaded (it will effectively be loaded and then unloaded). If you used variables for your forms rather than using the default instancing, you should never run into that issue.

[McNultyK]

Thanks for your reply. I understand the first half. Could you explain how to use variables for user forms? Also, is there any code that I can use to test if a userform is loaded or unloaded?

[romperstomper]

For the second part, you need to loop through the Userforms collection and check the names - for example:

Please Login or Register  to view this content.

To 'properly' use use userforms, rather than say using:

Please Login or Register  to view this content.

you use something like:

Please Login or Register  to view this content.

then when you want to unload the form:

Please Login or Register  to view this content.