User name code problem...
Posted by Jack on December 11, 2001 11:28 PM
In an Excel workbook I have the following codes:
User = Application.UserName
=IF(ISBLANK(A2),"",User() &" "&TEXT(NOW(),"m/d/yyyy-hh:mm AM/PM"))
The function code is stored in a module and the IF Statement code is stored in cell B2:B50. The sheet contains a header row. The idea behind the code is that the user enters date into cell A2 for example and thereafter their name and date and time of entry pops up in cell B2. This scenario is repeated each time an entry is made in column A:A.
Though this works well there is a problem. The workbook is used by several users. When a new user enters data into a cell in A:A, not only does the next cell in B:B change to show their details but all the used cells in B:B change to show their details. I had hoped that the code would only be applicable to each row and user but it is not. Any assistance with code to re-work this problem would be welcomed.