doubleclick linking

[bizdynamics]

I am using a worksheet that contains a column (e.g. Col. C) of dates (format is dd/mm). A second worksheet has one cell (Col. K, Row 3)that needs to be populated by the data from any one of the cells in Col C when I doubleclick on that specific cell. I would like to be able to jump to worksheet2!K3 when I doubleclick at the same time. How do I go about this. There are 875 rows in Col. C.
Tnx
Bob

 

[doofusboy]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 3 Then
        Sheet2.Range("K3").Value = Target.Value
    End If
End Sub

 

[bizdynamics]

Doesn't seem to do the trick... Or perhaps I'm missing something. Entered code in worksheet 1, and the worksheet just sits there and mocks me!

 

[doofusboy]

My bad, forgot the piece to redirect you to Sheet2. Try this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 3 Then
        Sheet2.Range("K3").Value = Target.Value
        Sheet2.Activate
        Sheet2.Range("K3").Select
    End If
End Sub

 

[bizdynamics]

Works perfect! Thanks much!
Bob