I've seen this class generator for VB6, but is equally applicable to VBA.
http://edais.mvps.org/Files/Full/PropGen/index.html

However, it runs as a standalone file, which is a bit of a pain.
Are there any free addins that can do this sort of thing integrated in the VBA IDE?
MZTools doesn't seem to have this capability.