title: Open userform when click in speficic column in table and read row values
body: <p><strong>System Description:</strong> I have created an inventory manager in Excel that tracks the quantity, location, and who is renting any given asset. In the master table of inventory <em>MasterInventory</em> on Sheet 1 (named <em>Inventory</em>), it shows all information including a column <em>Renter</em>- the person who is renting the asset, blank if no one is renting it.
  <br>I have already created the userform <em>Checkout_Form</em> and it works as intended but it needs to know which row was clicked in the <em>Renter</em> column to capture the asset's ID number to log the renting process.</p>
  
  <p><strong>Problem:</strong> When I click in the <em>Renter</em> column, I want <em>Checkout_Form</em> to open to allow the user to fill input based on the asset (which is reliant which row of the column was selected). </p>
  
  <p><strong>My Question</strong>: How do I create a link of some kind in <em>Renter</em> column that, when clicked, will open <em>Checkout_Form</em> and pass the asset ID (based on the row it's in) to it.</p>
  
  <p><strong>My Attempt:</strong> I have tried to use a macro for <em>Worksheet_SelectionChange</em> and check if the <em>Target</em> variable falls in the <em>Renter</em> column but I can't get it to work; it seems to be a problem with the column range I give and then I still don't know how to read the row's values.</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      Dim DesiredRange As Range
      Set DesiredRange = Worksheets("Sheet1").Range("MasterInventory[Renter]")
      If Intersect(Target, DesiredRange) Is Nothing Then Checkout_Form.Show
  
  End Sub
  </code></pre>
  
  <p>A button at the top of the sheet has not worked for me because there's no way to know which asset I'm currently working with.</p>