cell to equal user name

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
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
 
You can get the UserName which is the persons login ID.

MsgBox (Environ("UserName"))
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top