username on a cell only once
 

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

username on a cell only once
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Wanna Learn" wrote:

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