Hi,

I have one user form loading at the end of a macro that is using public variables. After the user clicks on a Command Button, a second macro is executed that uses the same public variables.
Without the user form, this works fine. But with the user form, the public variables are redefined and their values are lost.
Any ideas on how not to lose the values when having the user form?