checkbox identification

[devin]

Is there a way to bring back which check box was clicked without writing
code for the selected check box. Lets say I've got 400 check boxes 10
in each row with 40 rows. I don't want to write code for all 400 check
boxes. Any Ideas?

 

[Ron de Bruin]

Hi devin

If you use a checkboxes from the Forms Toolbar you can use Application.Caller

MsgBox ActiveSheet.Shapes(Application.Caller).Name