Get user informaation alaong with time

Hi,

I am facing on issue. I need user id with time. In column A if my team members activate the cell then I need current user id with time. Like below

akulka58 HH:MM:SS

I nee these for my checklist. If we put code or any custom function then can I share that workbook?

Till date I achived below code but it is not fulfilling my requirements.

Please Login or Register  to view this content.

Hi,

I don't think you want a Worksheet_Change(). I changed it to Worksheet_BeforeDoubleClick(), which means if you 'Double Click' in cells A1 thru C10, that cell will display the User Name and time.

If I didn't do what you want, please try to describe step by step what you want to do. For example:
a. User puts a value in cell 'A1'.
b. User Name and Time gets displayed in cell 'D1'.

See the attached file, which contains only the following code in Sheet1:

Please Login or Register  to view this content.

Lewis

LJMetzger, You are very valuable asset. Just wanted to check if we put code in workbook can we share it? If yes then please tell me how & if not then is there any other option?

Thank you for the kind words.

Yes you can share the code. The code is located in 'Sheet1' in the VBA area. You can copy to code to any sheet in the same or a different workbook.

How to copy the code.
1. Open the workbook that contains the code.

2. Open the destination workbook.

3. Access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module ('Sheet1').

4. Copy the code to the clipboard. It's the same as cut and paste in Microsoft Word.

5. Double Click on the destination Sheet. Paste the code into the destination sheet. If the words 'Option Explicit' are at the top of the module, make sure the words only appear ONE TIME. Remove any duplicate occurrences of 'Option Explicit'.

6. Save the Destination Workbook.

Lewis

Lewis, Thanks a lot for your help & valuable time.