Userform not passing through 1 particular public variable

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Is your string declared in a normal module or in the UserForm module?


Sent from my iPad using Tapatalk

Hey guys, thanks for the quick responses.

The public declaration is in the module, not the userform. Below is the code that defines divisionb


Below is the code that definies divisonb. Divisonbox is the input box in the userform.

Please Login or Register  to view this content.