title: VBA Excel Best Practices for using Forms and Classes together?
body: <p>I am new to using classes and would like to learn smart ways of integrating them with forms. Specifically, when you enter data into a form, should that form be tightly linked with a class and how?</p>
  
  <p>Let's use a simple example.  John is a collector of all kinds of cards: baseball cards, Pokemon cards, etc. He keeps his card list database stored in Excel worksheets and manages them using forms. There are forms for entering new cards and modifying their status in his collection, and there are also forms and functions for analyzing his data.</p>
  
  <p>So he might have a clsBaseball, a clsPokemon, a clsAlbum and a clsSalesRecord. He also has forms for entering and modifying data and other types of analysis forms that compare cards, calculate stats for various teams and time periods, etc.</p>
  
  <p>When John clicks the "New Baseball Card" button, his frmBaseball pops up. </p>
  
  <ol>
  <li>He enters baseball card data  </li>
  <li>He clicks Update</li>
  <li>The form is validated</li>
  <li>The data is saved onto the worksheet</li>
  </ol>
  
  <p>At any point in the above process is clsBaseball used?  I can see how the class would be used to load up all data in service of fancy sorting or statistical routines, but is it actually used during the entry phase such that the fields on the form have a direct effect on an instance of clsBaseball?</p>