Using Global Variables

[skull_eagle]

Hi, I'm setting up a sort of wizard where you make selections and move onto the next userform. There are 4 userforms in total and I want to set global variables to record the selections along the way.

I've set public variables outside of any sub or function
Public strFunction As String
Public strProcess As String

I've then set their values inside the sub
strFunction = ComboBox_Function.Value
strProcess = ListBox_Process.Value

When I try and use these variables at a later time to collate the results I get nothing
Public Sub UserForm_Initialize()
CF1.Caption = strFunction
CF2.Caption = strProcess
CF3.Caption = strSL
CF4.Caption = strSSL
End Sub

Any help would be most appreciated.

Thanks

 

[GTO]

...where you make selections and move onto the next userform. There are 4 userforms in total and I want to set global variables to record the selections along the way.

I've set public variables outside of any sub or function
Public strFunction As String
Public strProcess As String
...
....When I try and use these variables at a later time to collate the results I get nothing

Greetings,

When you say "outside", I presume you mean at the top of the Module. The question is: What kind of module, and (if you mean in the userform's module), has the userform that initially has the variables' declarations been removed from memory?

In general, you'd probably find it easiest to declare these variables in a Standard Module; or alternatively, you can pass the values (or objects, if any) from one userform to the next.

Mark

 

[skull_eagle]

Thanks GTO, I declared them in a standard module that contains nothing but a list of my variables. Works perfect.

 

[GTO]

You are most welcome and glad it is working