View Single Post
 
Old 08-25-2021, 02:21 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Not without VBA. Left-clicking difficult so this needs right-clicking.

See attached which has this code in Sheet1's code-module:
Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Range("B4").Value = Target.Value
End Sub
Attached Files
File Type: xlsm msofficeforums47553.xlsm (13.3 KB, 6 views)
Reply With Quote