automatically enter user name

[waynelong]

we have six people using two laptops. The two laptops are connected by a network. each person has his own login and user name. I am currently using this macro to automatically enter the date and time each person makes a entry into the excel log. I wish to add in column "C" to automatic enter of the user of the open excel sheet. can excel automatically pull the users name or initial (if we change it in the options menu) and place in cell "C" when a entry is made in cell "D"

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Yes it can, but before we can give you the answer you'll need to adhere to the forum rules and use code tags around your code.
Edit the post, highlight the code then click the # icon above your reply.

BSB

[waynelong]

Sorry, I would be more than happy to follow any rules. I just don't understand what you mean by code tags.

[BadlySpelledBuoy]

Follow the second line in post 2.

Please Login or Register  to view this content.

BSB

[waynelong]

I truly apologize for my stupidity, I understand you want me to use a message box. but I just don't understand how to produce a message box.

[BadlySpelledBuoy]

No, the msgbox thing was purely an example of how your code should look once code tags have been applied.

Try this:
1) Go back to your first post in this thread
2) Under the post is a button that says "Edit post". Click it.
3) Select all the text that makes up your macro code.
4) There's a little line of icons above the pane you're editing the text in. Near the right side of all those icons is one with a # on it. Click it.
5) Under the pane your editing in is a button that says "Save changes". Click it.

BSB

[waynelong]

I got it, Thanks

[BadlySpelledBuoy]

Now add this line of code to your current sub:

Please Login or Register  to view this content.

BSB

[waynelong]

Thank you working great