Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to equal user name
Hello I have a spreadsheet that different people complete. I created a
user form one of the fields is the name . Is it possible to have the user name appear on the text box instead of having the person typing his/her name this is what I have Private Sub Specialist_Change() End Sub thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to equal user name
You can get the UserName which is the persons login ID.
MsgBox (Environ("UserName")) "Wanna Learn" wrote: Hello I have a spreadsheet that different people complete. I created a user form one of the fields is the name . Is it possible to have the user name appear on the text box instead of having the person typing his/her name this is what I have Private Sub Specialist_Change() End Sub thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to equal user name
Thanks Joel
I'm a novice at this... I did something wrong This is what I did view code on the worksheet select user form selected Specialist txt box then view code below is what I did Private Sub Specialist_Change() MsgBox (Environ("UserName")) End Sub thank you so much for your help "Joel" wrote: You can get the UserName which is the persons login ID. MsgBox (Environ("UserName")) "Wanna Learn" wrote: Hello I have a spreadsheet that different people complete. I created a user form one of the fields is the name . Is it possible to have the user name appear on the text box instead of having the person typing his/her name this is what I have Private Sub Specialist_Change() End Sub thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |