If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|