checkbox identification

  • Thread starter Thread starter devin
  • Start date Start date
D

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?
 
Hi devin

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

MsgBox ActiveSheet.Shapes(Application.Caller).Name
 
Back
Top