O'Reilly logo

Programming Excel with VBA: A Practical Real-World Guide by Flavio Morgado

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required