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.
Bookmarks