© © 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

Flavio Morgado

(1)Rio de Janeiro, Brazil

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 ...

Get Programming Excel with VBA: A Practical Real-World Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.