How do I capture user's login data in a form

J

Jay

I want to set up a form in Word that contains questions with check boxes (yes
/ no ) etc. with the next field in the table set up to display the log in
information for the person who completes the form; i.e., if I check the box,
my name and completion time / date is captured and displayed in another cell
in the form.
 
F

Fumei2 via OfficeKB.com

You would have to supply more details on what determines "completion time",
but you could certainly grab a time stamp for when it is opened, and then
another for when they execute some sort of "Done".

Date? I would assume that would be the current Day. Yes? Look up Now in
help.

As for the login name. There are various ways, but Environ("username") is
the one of the easiest to use.

MsgBox Environ("username") & " " & _
Format(Now, "mmmm d, yyyy")

displays:

myLoggedInName January 21, 2010
 
Top