Thread: [Solved] Need help creating vba code
View Single Post
 
Old 10-25-2019, 03:42 PM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 10 Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 115
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

I can make this happen with a Before Double Click Event. This will need to be pasted into each Worksheet event. Could not develop a global event.

Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    ActiveCell.Offset(0, 4).Select
End Sub
Reply With Quote