Creating hyperlink on cell entry change

duncanc · Jul 22nd 2016

Hi

I'm trying to create a hyperlink to a folder whenever I add data to a cell in column C, however I'm getting a argument not optional in the Range.Cells... line. The code I'm using is

Code

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim strProspectNo As String
    Dim ThisRow As Integer
   
    strProspectNo = Target.Value
   
    If Target.Column = 3 Then
        ThisRow = Target.Row
        If Target.Value <> "" Then
           Range.Cells(ThisRow, 3).Hyperlinks.Add anchor:=Range(ThisRow, 3), Address:="C:\prospects\" & strProspectNo
        End If
    End If
End Sub

Display More

Any ideas what is going wrong?

skywriter · Jul 22nd 2016

Re: Creating hyperlink on cell entry change

Maybe, this.
Me is the worksheet the code is running against.

Code

Me.Hyperlinks.Add

You have to tell it was sheet, then the anchor is where the actual hyperlink will be.

Creating hyperlink on cell entry change

Participate now!

Share