It should be possible to set up a class for your ActiveX controls so that you don't need to create a set of Subs for each one. If you do a search for Class Modules you should be able to find the information you need to set this up correctly.

Here are some relevant links that will either give you the answer you need or show you the relevant keywords to do a better focused Google search
Textbox Class Object - TIP, TRICKS & CODE - OzGrid Free Excel/VBA Help Forum
Return active OLEObject in Worksheet - Excel General - OzGrid Free Excel/VBA Help Forum
Using change event of multiple ActiveX controls with no userform using class method - Excel General - OzGrid Free Excel/VBA Help Forum

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia