title: display searched data in listbox in vba
body: <p>I am new to VBA coding..</p>
  
  <p>help me in this situation..</p>
  
  <p>I have a table like in sheet 1</p>
  
  <p><a href="http://i.stack.imgur.com/7QwUh.png" rel="nofollow">Data table </a></p>
  
  <p>&amp; the user-form is like 
  <a href="http://i.stack.imgur.com/gYCc1.png" rel="nofollow">User form</a></p>
  
  <p>I need to display the searched data in this list-box...my logic which i have tried...</p>
  
  <p>1) a variable which holds the text-box value
  2) 1st tried with advanced filter but its not working
  3) then tried with find function it also shows error..</p>
  
  <p>I have tried but it does not display in list-box...it is my first working with  list-box...thanks in advanced.... </p>