Time stamp a cell using BeforeRightClick event

[SJV9]

Hi! any help please...

I found my solution here:

http://www.mrexcel.com/forum/showthread.php?t=393106

However, I just dont know how to modify the VB code that each time column A is right-clicked VB performs the time stamp in column G?

 

[Sahak]

Try This,

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 1 Then Target.Offset(0, 6) = Format(Now(), "HH:MM AM/PM")
End Sub

 

[SJV9]

Thank you Sahak! Just what I needed!

 

[Sahak]

You are welcome.