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?


---
Message posted from http://www.ExcelForum.com/

Hi devin

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

MsgBox ActiveSheet.Shapes(Application.Caller).Name


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"devin " wrote in message ...
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?


---
Message posted from http://www.ExcelForum.com/