title: Dynamic property names in VBA
body: <p>I have a custom class module in VBA (Access) that is supposed to handle a large amount of external data. Currently I have two functions <code>Read(name)</code> and <code>Write(name, value)</code> that allows to read and set dynamic properties.</p>
  
  <p>Is there a way to define a more syntactic way to read and write those data? I know that some objects in VBA have a special way of accessing data, for example the <code>RecordSet</code>, which allows to read and set data using <code>myRS!property_name</code>. Is there a way to do exactly the same for custom class modules?</p>