

Hooking an ActiveX Command Button in Class Module
This article describes how to assign an ActiveX CommandButton on a worksheet to a member of a custom class in a VBA project. When creating an application in Excel it is likely that somewhere you will want one or more clickable “buttons” in a sheet. A quick and easy way of doing this is to add a “Shape” to the sheet, right-clicking it and selecting “Assign Macro”. You can then write code that will run when the shape is clicked by a user. This is a neat solution because the app