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.BeforeClose) and a punch of generic procedures that use module-level constant values to load, save, and delete worksheet ...
© © The Editor(s) (if applicable) and The Author(s) 2016
Flavio Morgado, Programming Excel with VBA, 10.1007/978-1-4842-2205-8_8
8. Creating and Setting a Worksheet Database Class
(1)Rio de Janeiro, Brazil