I have a userform that is called within a sub in module. I declared a public string, "divisonb", in the module. When the userform's ok button is clicked, I define the public string through a "select case" method.

At the end of the private sub for the ok button click I have this:
MsgBox (divisionb)
Unload Me
a message box comes up with the correct string for divisonb. After the sub ends and it returns to the module I have the following:


userform.show 'This was the userform that just ran

MsgBox (divisionb)
When this message box pops up, it is blank. Somehow, divisonb was redifined as blank within that 2 lines of code. Anyone know why? All my other public strings are returned to the module with their correct values.

Thanks...