title: Create Hyperlink using textbox on UserForm and Path specified
body: <p>I have a table for users to import new info/data onto, using a UserForm.</p>
  
  <p>I would like the User to type the document name because the File is not labeled correctly (which I don't care much about) I would like the textbox to be the label for the hyperlink and the Path be selected by the user after they've moved the file into it's appropriate folder. </p>
  
  <pre><code>Private Sub cmd_ADD_Click()
      'Copy input values to table2.
  Dim ws As Worksheet
  Set ws = ActiveSheet
  Dim tbl As ListObject
  Set tbl = ws.ListObjects("Table2")
  Dim newrow As ListRow
  Set newrow = tbl.ListRows.Add
  Dim Label17 As String
  Dim txtDrawing As String
  
  With newrow
  </code></pre>
  
  <p>this line worked originally</p>
  
  <pre><code>    .Range(13) = txtDrawings.Value
  </code></pre>
  
  <p>now I need that value, when added to be a hyperlink. I tried this...</p>
  
  <pre><code>    .Range(13).Hyperlinks.Add(Anchor:=.Range(13), _
        Address:=Label17, _
        ScreenTip:="DRAWING", _
        TextToDisplay:=txtDrawings.Value)
  </code></pre>
  
  <p>and this... </p>
  
  <pre><code>    .Range(13) = .Hyperlinks.Add(Label17, Me.txtDrawings.Value)
  
  End With
  
  End Sub
  </code></pre>