Accessing Userform Variable Values in Module

[xlnc4all]

Hi All, I have a userform which has two variable and I want to use those variable values in multiple Modules

'Userform Submit Code

Private Sub SubmitButton_Click()

If Me.ComboBox1.Value = "" Then
MsgBox "Please Enter Period Value"


ElseIf Me.ComboBox2.Value = "" Then
MsgBox "Please Enter Fiscal Year"


ElseIf Me.ComboBox1.Value <> "" And Me.ComboBox2.Value <> "" Then
Period = Me.ComboBox1.Value
FY = Me.ComboBox2.Value
Unload Me
End If


End Sub

******************Below is my Module*****
Public Period As String
Public FY As String

Sub MyModule()

Period = 'Here i want userform Period value
FY = 'Here i want userform FY value

End Sub

Thanks in advance

 

[Momentman]

Probably declare them as public at the top of one of the modules so they are available to all procedures/modules

 

[xlnc4all]

Probably declare them as public at the top of one of the modules so they are available to all procedures/modules

Thanks a lot..it worked!!!

 

[Norie]

You can refer directly to the userform an it's controls in the module, provided the userform is still loaded.

So you could have this in the module,

Period = UserForm1.ComboBox1.Value
FY =UserForm2.ComboBox2.Value

and in the userform.

Me.Hide

Call MyModule

Unload Me