Excel 2007 : Sending Cell Data on Hyperlink Click

[bush1282]

I have a column with a large number of rows that contain activity numbers - 1 activity number for each cell. Each of these cells has a hyperlink set, so that when the user clicks on the link, they are taken to a different cell in the same sheet.
I wanted to be able to send the cells data (the activity number) to the destination cell.

For example:
C2 = 1-YKCQ8O8
C3 = 1-YRSRNMB
C4 = 1-Z1AGVE0

M5 is my destination cell.

I hoping to be able to get cell M5 to display 1-YKCQ8O8 if I click on that link in cell C2.
But, M5 has to be able to display 1-Z1AGVE0 if I click on the link in cell C4, etc.

Any ideas?

While searching for an answer, I was able to find this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim iColumn As Integer, iRow As Integer
With ActiveSheet
iColumn = Target.Column
If iColumn = 3 Then
    iRow = Target.Row
    Cells(5, 13) = Cells(iRow, 3)
    End If
    End With
End Sub

That would do nothing for the the clickable hyperlink, but if you double-clicked the cell, it would send the data to cell M5.

Any help would be greatly appreciated.