Name of active checkbox

**anteagles20** · 08-23-2012, 09:49 AM

Hi,

I have several activex checkboxes on a worksheet. In the click event for each checkbox I have code which calls a sub routine. I need to pass the name of the selected checkbox to the sub routine. Would I have to explicitly declare the name of the checkbox e.g.
mysubroutine "Checkbox1"

or is it possible to do something like:
mysubroutine activecheckbox

Thanks

Ant

**anteagles20** · 08-23-2012, 10:42 AM

Does anybody have any ideas? After looking into a bit more it seems there is an activecontrol command but this is only for controls on a userform, not a worksheet. Does anybody know if there is an equivalent for a worksheet control?

Thanks