How to get date and time after double clicking in particular cell.

[PrincePrashant]

One of my friend prepared some checklist where all the required staff was asked to put processor id in one column and in other the current date and time. When we double click the cell then automatically the processor id and date & time get pop up. I tried from my end but did not get any answer. Processor id means company provided login id which we use to login into citrix and open all required excel, outlook and other applications.

 

[admiral100]

Hi,

Try this : column A contain the processor id and column B the date&time

Sub Popup()
For i = 2 To Cells(Rows.Count, "A").End(xlUp).Row


Range("A" & i).ClearComments
Range("B" & i).ClearComments

If Range("A" & i) = "" Then GoTo 1

Range("A" & i).AddComment
Range("A" & i).Comment.Visible = False
Range("A" & i).Comment.Text Text:="" & Range("A" & i).Value & " - " & Range("B" & i).Value
1
Next i
End Sub

 

[PrincePrashant]

Can this be done without macro and vba coding.

 

[admiral100]

If it is okay with you to enter the processor id in D2 then E2 will display the date

E2 =INDEX(B2:B8,MATCH(D2,A2:A8,0))

 

[PrincePrashant]

Thank You

I will try this and will let you know.