TobyCobbin
New Member
- Joined
- Feb 6, 2014
- Messages
- 7
I've got a "submit" button on my Excel spreadsheet and I would like to know what script/command to add to the assigned macro so that when the form is received by a second user (authoriser) it has the name and date/time tag of the person who submitted the form (form completer).
Is there anyway of looking at the user who is logged into the pc and "capturing" that information?
So once the form has been submitted, in the cell next to the submit button I need it to show something like: MR USER1 08/02/2014 10:08
Similarly, I'll need to do the same on a second submit button so the end view looks like:
MR USER1 08/02/2014 10:08
MRS USER2 09/02/2014 15:37
Any help/comments would be greatly received.
Is there anyway of looking at the user who is logged into the pc and "capturing" that information?
So once the form has been submitted, in the cell next to the submit button I need it to show something like: MR USER1 08/02/2014 10:08
Similarly, I'll need to do the same on a second submit button so the end view looks like:
MR USER1 08/02/2014 10:08
MRS USER2 09/02/2014 15:37
Any help/comments would be greatly received.