title: Click CommandButton to display UserForm with URL link
body: <p>I am trying to code CommandButton1 to display UserForm1. In Userform1 I would like a hyperlink that uses values from cells in the worksheet. I would like UserForm1 to unload when the link is clicked.</p>
  
  <p>I will put down what I (think) I know. But I am missing most of the code. Specifically:</p>
  
  <p>How do I actually display the link?</p>
  
  <p>How do I code to dismiss UserForm1 when link is clicked?</p>
  
  <pre><code>Private Sub CommandButton_Click()
      UserForm1.Show
  End Sub
  
  Private Sub UserForm1_Click()
      Dim URL As Hyperlink
          URL = "http://www.example.com/" &amp; Cells.Range("Q5") &amp; "/index"
      ...
  End Sub
  </code></pre>