The VBA Help blog

Most VBA developers only ever consume events like Worksheet_Change. But you can declare and raise your own. This post builds a small worker Class that raises events and a listener that handles them ... without the Class knowing who's listening.

Show a UserForm with a ListBox which can be filtered by typing one or more characters into a TextBox.

How to add Ribbon controls (a button and a ComboBox in this post) to an AddIn

How to create an Excel AddIn and use it to listen Excel application events using VBA code.