title: Pull data by searching unique ID
body: <p>I am new to VBA. I just managed to create my form and populate excel.
  I would like to know if there is a way to create a new button that would pull info if it finds the unique ID.</p>
  
  <p>For example:</p>
  
  <pre><code>Unique ID   Name     Place
  1         John Doe   X
  2         Jane Doe   Y
  3         Tim Doe    Z
  </code></pre>
  
  <p>So for example, in the form, next to "Add" (which gets data in worksheet) I would like to have "Search for:" over here I would type the Unique ID and have all the other cells populated with info.</p>
  
  <p>I am sorry if I should have provided more info. I am new to VBA. If needed, I can copy+paste the code.</p>
  
  <p>If I add info and hit "Add this part" it auto-completes in excel on rows (A1: Unique ID; B1: Name; C1: Place).</p>
  
  <p>I want to add another button like "Search" with this action: Click > Asks for Unique ID > It searches for the data typed > If it finds something populate textboxes with info(the row where SR is on A:A)</p>
  
  <p><img src="https://i.stack.imgur.com/DO26v.png" alt="enter image description here"></p>