Triggering vba from a cell contents

[PJS Soft]

Hi,

This may be an easy one but it's just not standing out to me.
I have a Data List on a sheet (the log) that stores all the info inputted from a user form.
The data can then be viewed as a printable layout on another sheet using a macro to ask for the reference number then copy all the data across.

I have that side of things working however what I'd really like to do is make the reference number in Column A on the log a hyperlink that when clicked triggers the same macro but doesn't ask for the reference number because it uses which ever reference was clicked on.

Any ideas?

Thanks in advance

 

[tweedle]

you can either look at
Worksheet_SelectionChange if you're working a single sheet
or
Workbook_SheetSelectionChange if there are multiple sheets to trigger from

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If _
        Target.Column = 1 And _
        Target.Cells.Count = 1 Then
 
        Call YourSpecialRoutine_Here(Target.Whatever)
    End If
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
 
    If _
        Sh.Name = "your Special Sheet Name Here" And _
        Target.Column = 1 And _
        Target.Cells.Count = 1 Then
 
        Call YourSpecialRoutine_Here(Target.Whatever)
    End If
End Sub

 

[PJS Soft]

Superb thanks very much Tweedle

Just the job