username on a cell only once

W

Wanna Learn

Hello I created a form and on cell D7 I want the user name( the first
person completing the form . ) the problem is that after the form is
completed the person will submit the form to another person for further
action. however I want D7 to always have the name of the firt person who
submitted the form . IS that possible? thanks in advance
 
L

Luke M

To have a variable value become static, you're going to need to use VBA.
You could make a command button that the original user clicks when they are
done with the form, which activates a macro like the following

Sub FormComplete()
Range("A2").Value = Eviron("username")
End sub

You could also make it so that the macro deletes the command button (simply
record yourself doing this to get correct code) to help preserve the author's
username.
 
Top