label control

[bhandari]

i have one user form,it have Label1
I want to link my Label1 with "user administrator name"

i mean "windows user name"
can we get it automatically when userform pop up

 

[bhandari]

INstead of Label 1 Iam looking for "Windows username"

 

[Rick Rothstein]

INstead of Label 1 Iam looking for "Windows username"

Try using this code line in the UserForm's Initialize event...

Label1.Caption = Environ("username")

 

[mumps]

Place this macro in the code module for your userform:

Private Sub UserForm_Initialize()
    Label1.Caption = Application.UserName
End Sub

 

[Rick Rothstein]

Place this macro in the code module for your userform:

Private Sub UserForm_Initialize()
    Label1.Caption = Application.UserName
End Sub

In Message #2 , the OP clarified that he wanted the Windows' username (hence what I posted)... your code gives the Excel username.

 

[mumps]

Thank you, Rick.