Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Cell Comments Username does not appear | Excel Discussion (Misc queries) | |||
Show username in a cell | Excel Discussion (Misc queries) | |||
Including Environ Username in Cell | Excel Worksheet Functions | |||
Saving username into a cell | Excel Worksheet Functions | |||
How do I populate a cell with the NT Logon username? | Excel Discussion (Misc queries) |