Public Variable

Its not the public deleration of user as the problem. When you Unload the userform, it looses all the data. including the value of user. I'd recommend that you hide, rather than unload the form.

Please Login or Register  to view this content.

or use Repaint

Please Login or Register  to view this content.

When I put Hide Me - it returns Compile Error: Wrong number of arguments or invalid prperty assignment

When I use withour Hide Me:

PHP Code: 

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


UserForm1 loads but user is not showing.

When I use:

PHP Code: 

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


and click the button nothing happens.

Hello Digitborn.com,

Move your statement Public user As String to the Delcarations sections of a Standard VBA Module. All your Forms as well as anyother code will have access to this Public Variable.

Sincerely,
Leith Ross

That's it! This time it works. I didn't recognize that before you tell me, thanks!