I have written code for Choicer, which is a Class Module. Broadly, the Choicer does two big things: it constructs a bunch of tables, and it puts Validation drop-down menus into cells. There's a lot of code in the module; it's getting hard for me to navigate. I'd like to split the module into two modules.
For a regular module, this would be no problem. For a class module, how do I do it? I don't want to create two different classes; I want to spread the code for a single class across two files.
If VBA had inheritance, I'd code two separate classes and let Choicer inherit both of them. Is there a comparable approach in VBA?
Bookmarks