cell to equal user name

W

Wanna Learn

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
 
J

Joel

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

MsgBox (Environ("UserName"))
 
W

Wanna Learn

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
 
Top