So I plugged in the
Type method and made it it work, but I quickly discovered the argument against
Types. I have 4 more
Types to make that have different information and more importantly different amounts of variables withing the
Type. I now have five
Types that cannot use the same
addEntry sub. The journal entry, for example, has 3 data; the hours entry has 4 data; the materials entry has potentially 7 data. So, I can
generic-ize the
Type with an identifier & common data like date and time, and say, 10 variables as
Objects named
myObjOne through
myObjTen to cover the varying other data that might fall into the
Type. That could be handled by a
Select Case, but I find most of the time that a
Select Case doesn't really mitigate the
DRY code factor and that I would be better off eliminating the
addEntry sub, and handling the process individually under the saveEntry button.
So back to the drawing board. I will add the entries on an individual basis executed by the
saveEntry button, and therefore not be required to create the
Type afterall.