title: Using .Autofilter , using results in Textbox.value
body: <p>Im using .autofilter to filter a list in excel, my problem is i want to have the results from the autofilter populate textboxes. i know i can use something similar to </p>
  
  <pre><code>textbox.text = Data(a1).value
  </code></pre>
  
  <p>however as the cells are filtered they keep there original cell location so i cant just use the cell location. There will only ever be one result to the filter so i need something that populates the text boxes from the row just under the filter heading.     </p>
  
  <p>for back ground the over all idea is to have a spread sheet that can be searched from a userform, which currently works, and then display the results in text boxes. Keeping the user of the spreadsheet away from the raw data as possible.</p>