Each Stakeholder of A File Must Select His Name (Only)
 

I am imaging this situation: There is a file (shared or non-shared) ,
to which several users have access. These users enter data in their
responsible areas.What I would like to see is that after an user
enters the data, he types or selects from a dropdown box his name, so
we all know who makes the entry. The problem is that if he has to
select a name from a dropdown box, how to avoid selecting another
user's name? If he must type his name, how to prevent him from typig
another user's name?

Could you please point me to a right direction?

Thanks in advance.

H.Z.

Each Stakeholder of A File Must Select His Name (Only)
 

You can use the envirnmental variable username instead using a dropdown box

MsgBox (Environ("USERNAME"))

"Curious" wrote:

I am imaging this situation: There is a file (shared or non-shared) ,
to which several users have access. These users enter data in their
responsible areas.What I would like to see is that after an user
enters the data, he types or selects from a dropdown box his name, so
we all know who makes the entry. The problem is that if he has to
select a name from a dropdown box, how to avoid selecting another
user's name? If he must type his name, how to prevent him from typig
another user's name?

Could you please point me to a right direction?

Thanks in advance.

H.Z.