auto entry or date and time when you tab into the cell

[alebeouf]

please assist I am tryin to auto enter date and time in a cell when you tab into the cell can any one assist

[#2]

@alebeouf 

I don't know what exactly you want because they didn't have a file attached. It would be an advantage if a file (without sensitive data) were included, so you could come to a solution more quickly.

Anyway, here is a solution with VBA where you can adjust the range and let the date appear automatically with the right mouse button.

Option Explicit

Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean)
Me.Unprotect ("1234")
   
     If Not Intersect(Target, Range("A10:B1009")) Is Nothing Then
        Target = IIf(Target = "", Date, "")
        Cancel = True
    End If
     
    Me.Protect ("1234")
End Sub

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.