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
|