How Do I Get the Value of a CheckBox that Made Macro Call

[MikeMcCollister]

I have a spreadsheet that has a checkbox on it. Because this spreadsheet will be edited many times, the checkbox will ultimately have multiple copies. Each checkbox will be calling the same macro. I want it this way because I don't want to create a new macro whenever I edit the spreadsheet. The ultimate plan is to have all checkboxes change to state of the checkbox that was just checked. So, is there a way to detect the state of the checkbox that triggered the macro?

Thanks,

Mike

 

[MikeMcCollister]

Yes, trying to make it white on a dark background.

 

[Fluff]

In that case I think you're out of luck as far as form controls go.

 

[MikeMcCollister]

Fluff,

Thanks so much for your help. I think that I have enough understanding of the control that I can make the appropriate compromises.

Regards,

Mike

 

[Fluff]

You're welcome & thanks for the feedback.