Public Variable

Hello,

I have a problem with using one variable (username) in several UserForm captions. My code is:

UserForm - frmLogin

PHP Code: 

Option Explicit
Public user As String

If i = "secret" Then MsgBox ("Successful 1 - John!")
       Unload Me
user = "John"
       UserForm2.Caption = "Admin - " & user
       UserForm2.Show 


UserForm2.Caption is correct but then:

UserForm1 code:

PHP Code: 

Public user As String
Private Sub CommandButton5_Click()
    Unload Me
    UserForm1.Caption = "Form 1 - " & user
    UserForm1.Show
End Sub 


On UserForm1 the Caption is not showing