Global variable declared in Userform. Variable value is not sticking

Hey,

Im in big need of getting this one solved, so hope someone can help me.

As is easier seen in the attachment, I set my variable myName to be the Combobox1.Value

I want this value to stick with the variable, so that when I activate Sheet2, myName still equals whatever I was set to in the userform. This is not the case though, since variable value is empty when I activate another sheet. Guess it has something to do with my declaration of the variable, but cant figure it out. Please help Thanks in advance!!

Please Login or Register  to view this content.

Thanks for your reply. I see what you mean, but how exactly would you declare the variable as you suggest? If I declared the varialble in another module, I cannot set it equal Combobox value, cause the userform is closed. Also, since I assume unloading and manually closing the userform has the same effect, I cannot activate another sheet after closing the userform without losing the variable value. Or am I missing something? Thanks again.

Very nice, that actually works! One last thing, which is nice if you could clarify also:
In the userform code I still set myName equal ComboBox1.Value, hence I need to state Dim of myName cause I have Option Explicit on top of the userform module. But (maybe cause myName appears in the Public declaration in my other module) I get myName = "" when activating sheet2 (if I have Dim for myName in the userform code).
I can of course survive without Option Explicit in the userform code and then it works, but if you know a way to keep O.Ex, I would be happy to hear it

My bad, dont know why I couldn't make it work before, cause now it does! Thank you so much for all your help!