Sep 23 2020 04:35 AM
How do I get the right click to work in Excel when entering data. I am using Excel online. thank you.
Sep 23 2020 08:21 AM
With this VBA code you can display the current date 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("A2:A10")) 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.
Sep 23 2020 08:28 AM