Mike Wolfe

Check out this trick for reducing boilerplate code: maintain a private collection of objects that are instances of the class itself.

Using WithEvents to subclass form controls is a powerful technique. Here's one way to handle multiple control types in a single class.

You don't need to call the event handler for every control to handle its events. Instead, you can use WithEvents to encapsulate that code in a class module.

This quick tutorial will have you writing custom events in VBA in no time.