Creating a Settings Class in VBA

In .NET they have a nice settings class you can create using ApplicationSettingsBase base class. In VBA it takes a bit more work to get it working, but can be fairly elegant if done correctly. Some criteria that is needed for a settings class in vba are: Well formed Fast lookup Default setting Single input/output procedures. To make it well formed I used an enumeration variable type to create each setting. [Read More]