Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet which I share with four other people, and I need to
have their login username (the variable is called sName) as part of their data entry. What I need is a way to fix the following problem. Their last line of data entry is a Time variable which is entered into Column N, and is used later to verify that data has been entered in that particular Row. One of the problems is that after they enter a time, not all of them use the same key to move to another cell. For example, when inputting the time in Cell "N7", User1 uses the [Enter] key, causing Cell "N8" to be the new active cell; User2 uses the arrow keys, which means that there are four possible destinations for the new active cell; and all occasionally hit [PageUp] or [PageDown] in error. Given the above problem, I need WorkSheet code to automatically enter sName in the next Column of the row directly after the Time entry, i.e. 12:06 is entered in "N7", so User login should automatically appear in "O7" 13:30 is entered in "N8", so User login should automatically appear in "O8" etc. Any help would be appreciated. Regards McBarker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Username upon Entry | Excel Worksheet Functions | |||
userName | Excel Programming | |||
UserName | Excel Programming | |||
username | Excel Programming | |||
Get NT Username | Excel Programming |