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