Public Variable As String

[Formula11]

It seems that a Public variable declared in one module is available in others as well.
But what about assigning the value to the variable in one module to be made available in others.

Public InitialPart As String

'Module 1
Sub UserInput()
    InitialPart = "This is the initial part"
End Sub

'Module 2
Sub Test()
    Msgbox InitialPart
End Sub

 

[RoryA]

That should work as long as you run the first routine before the other one.

 

[Formula11]

Hi. I'm not running the first routine though. It's just there to assign a value which I'll use in other modules.

 

[Yongle]

Public Const InitialPart As String = "This is the initial part"

 

[Formula11]

Great. Thanks.