Auto update Form Text box with form editor name

[Seacowdaz]

Hello,
I’m not sure if what I want to do is possible but I have a user form (screenshot attached) what I would like to know is if there is a way to automatically update the ‘Agent’ field with the name of the person updating the form?

 

[Fluff]

Cross posted http://www.vbaexpress.com/forum/showthread.php?62667-Auto-update-Form-Text-box-with-form-editor-name

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

Something along the lines of

Private Sub UserForm_Initialize()
Me.Label1.Caption = Environ("username")
End Sub

 

[Seacowdaz]

Hello thank you for your reply, first of all i'm sorry for cross posting, i didn't realise it was the same forum.

secondly, with the above sub do i add this as a sub for the text box i am using?

 

[Fluff]

i'm sorry for cross posting, i didn't realise it was the same forum.

They aren't the same forum, but a lot of the members here also post to other sites. Please read this to understand Excelguru Help Site - A message to forum cross posters

The code I supplied needs to go in the UserForm_Initialize() sub in the userform module

 

[Seacowdaz]

Hello thank you for your reply, first of all i'm sorry for cross posting, i didn't realise it was the same forum.

secondly, with the above sub do i add this as a sub for the text box i am using?[/

I've figure out how to use the Sub. and i relaly appreciate the help. at the moment it shows the username but is there anyway of changing this so that if the username is SmithJ1 for example then John Smith Shows in the field instead?

 

[Fluff]

How do we know the name of the person?

 

[Seacowdaz]

the only way i would know would be by knowing the person. if thats what you mean, sorry for not being clear

 

[Fluff]

If the username is SmithJ, but you want to display John Smith.
How would the macro know that SmithJ is John Smith as opposed to Jane Smith?
Do you have a list of usernames/full names?