excel VBA double click go to cell value

Question

i have the code that copy/pastes a value from a cell in a range to a target cell

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Range("A2:A1000"), Target) Is Nothing Then
        Application.EnableEvents = False
        Range("B1048568") = Target
        Cancel = True
        Application.EnableEvents = True
    End If
End Sub

What values do I need to change to do "goto" instead of copy/paste? I have a list of values on column "A" and the same values as headers on cells "D:Z" I want by double clicking on a cell in column "A" to go to the cell with the same value on the range "D:Z"

Mr. Mascaro Mr. Mascaro · Accepted Answer · 2014-11-03T15:49:14

-1

votes

You need to find the cell and then use the Activate method of that cell.

excel VBA double click go to cell value

1 Answers