title: Populate textbox's with spreadsheet data based on dropdown selection excel
body: <p>I am creating a user interface to use on an inventory spreadsheet. In this example, I am trying to display the details of a selected user for edit or delete purposes.</p>
  
  <p>I intend to use a loop to iterate through a column of usernames, stop when it hits the selected username, and populate the shown entities with values obtained from the spreadsheet (these details are in the same row as the username) </p>
  
  <p>Below is an example of what the code will look like.</p>
  
  <pre><code>Dim nameRange As Range
  Set nameRange = Range("A2:A100")
  
  For Each x In nameRange
      If x = UserFrameUserDropdown.Value Then
          UserFrame_FName.Value = **&lt;code to go here&gt;**
          UserFrame_LName.Value = **&lt;code to go here&gt;**
          UserFrame_Country.Value = **&lt;code to go here&gt;**
          UserFrame_State.Value = **&lt;code to go here&gt;**
          UserFrame_Position.Value = **&lt;code to go here&gt;**
          Exit Sub
      End If
  Next
  </code></pre>
  
  <p>Any assistance is appreciated.</p>
  
  <p></p>