How to pass public variable value from user form command button to other module

[z3115]

I have a macro that calls a user form. When the user clicks the "ok" button on the user form, a command-button-click macro runs, which sets a global variable ("formVal" to the value of one of the form fields. All that works well. My issue is when I then run a macro in a different module (but same workbook) the global variable is null.

Here is the code in the user form. "msgboxtest" works when placed on the userform code page, but when I move it to a module it shows that the variable is null. (I also have "Option Explicit Public formVal as String on the module code page)

Option Explicit
Public formVal As String

Private Sub CommandButton1_Click()
    formVal = ComboBox1.Text
    SGF.Hide '(SGF is the name of the user form)
    Call msgboxtest
End Sub


Sub msgboxtest()
     'This works fine when I have it one the same page as the user form code, but when I move it to a module it says the variable is null
     MsgBox formVal
End Sub

 

[Fluff]

This line

Public formVal As String

needs to go in a standard module, rather the the UserForm module

 

[z3115]

This line

Public formVal As String

needs to go in a standard module, rather the the UserForm module

I have the "Public formVal As String" in the standard module as well, at the very top of the module page.

 

[Fluff]

It should only be declared once in any workbook, so remove it from the userform module

 

[z3115]

It should only be declared once in any workbook, so remove it from the userform module

That worked, thank you so much! If you don't mind, can you explain why it didn't work when it was only in the user form? Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback
Any public variables declared in Sheet modules, ThisWorkbook module, or userform modules are only available to code in that module.