Generic Current Object Reference Inside that Object's Code

**Aegwyn11** · 11-01-2012, 09:55 PM

I'd like to make some checkbox code that is generic so that I can cut/paste it from one checkbox to another without having to modify each time. I'm almost there, but there's one last thing. I'd like to make a generic current object call instead of the specific object call...in this code I would like to change CheckBox2.LinkedCell to something more generic.

Please Login or Register  to view this content.

**6StringJazzer** · 11-02-2012, 09:44 AM

The code doesn't know what checkbox the event is being processed for, except for the name of the Sub. There is an alternative approach to implementing events for several controls, if they all have the same code. The attached example [handle multiple buttons by creating a class.xls] comes from John Walkenbach, and shows how to implement a Class that handles an event for all instances of a specific control type. In this example, there is a userform with several command buttons, and there is one Sub to handle all clicks no matter what button it is.