• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get user Signatur

Gamnis

New Member
Hi

Right now i'm trying to find a way to copy the name or signature from the user thats logged in to the computer


I have seen this work but I have had some trubble finding an example of it.

So I hope some on of you guys can help me?


EX:

The user fills out my form and then presses a button (VB-skript) that transfers the data to another sheet or a database. This is were I want to logg the one who is inserting the data.

data 1/data 2/.../.../[Initial of user]


All comments and tips are welcome!


Best Regards

--

Gamnis

(I'm Swedish so I hope you will excuse spelling errors and funny sentences)
 

Clarity

New Member
hI,


I've used "Environ("username")" in code before to get the name of the user.


Add this code into your VBA and run it to see if the text in he message box is what you are looking for:


Sub test()

MsgBox Environ("username")

End Sub


Myles
 

Gamnis

New Member
Nice!

Thanks alot Myles :)


I just wrote the skrip like this:


Activecell.Value = Environ("username")


It worked out exactly like I whanted
 
Top