cell to equal user name
 

Hello I have a spreadsheet that different people complete. I created a
user form one of the fields is the name . Is it possible to have the user
name appear on the text box instead of having the person typing his/her name
this is what I have
Private Sub Specialist_Change()

End Sub
thanks in advance

cell to equal user name
 

You can get the UserName which is the persons login ID.

MsgBox (Environ("UserName"))

"Wanna Learn" wrote:

Hello I have a spreadsheet that different people complete. I created a
user form one of the fields is the name . Is it possible to have the user
name appear on the text box instead of having the person typing his/her name
this is what I have
Private Sub Specialist_Change()

End Sub
thanks in advance

cell to equal user name
 

Thanks Joel
I'm a novice at this... I did something wrong
This is what I did
view code on the worksheet
select user form
selected Specialist txt box then view code
below is what I did
Private Sub Specialist_Change()
MsgBox (Environ("UserName"))

End Sub
thank you so much for your help



"Joel" wrote:

You can get the UserName which is the persons login ID.

MsgBox (Environ("UserName"))

"Wanna Learn" wrote:

Hello I have a spreadsheet that different people complete. I created a
user form one of the fields is the name . Is it possible to have the user
name appear on the text box instead of having the person typing his/her name
this is what I have
Private Sub Specialist_Change()

End Sub
thanks in advance