title: Putting Excel Tables into a Custom Class
body: <p>I'm new to using VBA classes, and I think what I want to do -- using them with ListObjects -- is more of an "intermediate" than "beginner" technique.</p>
  
  <p>Let's say I have two tables related to cars. </p>
  
  <pre><code>tblCarDesc
  ID   MAKE        MODEL      DOORS     ENGINE
  1    Chevrolet   Corvette    2         V8
  2    Ford        Escort      4         V6
  3    Rolls-Royce SilverCloud 4         V8
  
  tblCarProd
  ID      COUNTRY  TYPE
  1       US       Sport
  2       US       Economy
  3       UK       Luxury
  </code></pre>
  
  <p>(The same cars are in both tables, and shown by the ID numbers.)</p>
  
  <p>I want to have a class called objCars that includes the fields (columns) from both tables. That way, when referring to Car #3, objCars.Make would be "Rolls-Royce" and objCars.Type would be "Luxury".</p>
  
  <p>1) Is there a way to import both tables into objCars? </p>
  
  <p>Perhaps I would create an array big enough to hold all the columns, then load both tables into it. The tutorial I've been reading says that I would then create a Collection, loop through each row of the array, make a new instance of objCars, and assign objCars.Make, objCars.Model, etc., for each row.  Then each item of the Collection would contain a car. (Or something like that. I don't really know much about Collections either.)  If that's right, is it the best way?</p>
  
  <p>2) How exactly does one refer to a specific car? The examples I've read like to loop through Collections and work on each item therein, but what if I want to extract a particular item? I know the Ford is Car #2; how do I get the objCars.Make and objCars.Model for that particular ID number?</p>