title: Excel 2007 ,VBA form to filter worksheet records based on condition
body: <p>I have a list of records that I want to work with it through VBA form.</p>
  
  <p>for ex: below records list</p>
  
  <pre><code>ID          Score   Date  
  ------------------------------
  228483      80      5/10/2011  
  243216      60      4/3/2011  
  285483      40      5/1/2011  
  291584      30      5/2/2011  
  291323      70      4/4/2011  
  285607      40      5/7/2011  
  7158441     90      5/8/2011  
  7083234     10      4/2/2011  
  </code></pre>
  
  <p>I would like to have a vba form having multi form components which each will list the records from this above list based on condition.</p>
  
  <p>for example on the top left the component will list records who scored over 50, and on the top right another component from the same type will list records achieved during month# 5.</p>
  
  <p>I 'm not that much in VBA forms and really don't know what component will do that and how.</p>
  
  <p>Will any changes in the worksheet be reflected directly to the lists in the vba form?</p>
  
  <hr>
  
  <p>Thanks brother Jonsca and harag for the great support and yes I'm looking something like DataGridView that is a scrollable and sortable table retreived from database based on condition..I tried to look for "Microsoft Office Spreadsheet" but it seems it need some work around for excel2007 to add it but my question is , could we have this in simpler way for example a local web page could be connected to excel sheet and have the same control in it....I made a sketch for what i'm looking for </p>
  
  <p><a href="http://img849.imageshack.us/img849/3834/13125375.png" rel="nofollow noreferrer">http://img849.imageshack.us/img849/3834/13125375.png</a></p>
  
  <p>Is it easier to build a danamic connection between web page to worksheet (and with having this control)...big thanks brothers in advance.</p>