Creating and Setting a Worksheet Database Class

Abstract

In the previous chapter you studied how to use Excel as a database repository, using a programmable approach based on a data validation list filled with a New Record item followed by all saved records and a simple strategy to save any one-to-many record database relationship on unused worksheet rows. The database engine was based on some Excel object events (Worksheet.Change, Worksheet.SelectionChange, and Workbook events.BeforeClose) and a punch of generic procedures that use module-level constant values to load, save, and delete worksheet application records.