How To: Reference a Check Box in VBA

[enichols]

How do I reference a check box from another worksheet in my VBA code? I want to code that if the box is checked in Sheet1, to then copy a range of cells from Sheet1 onto another worksheet, Sheet2.

Thanks!

EDIT: I've attempted to reference my check boxes from sheets PCAPV10, PCAPV16, AND PCAPV22 in the code below. I'm getting an object error.

Please Login or Register  to view this content.

*This question has also been posted on Stack Overflow as I need an answer ASAP. Excel Forum will not allow me to post links yet, so my apologies for not linking the post.

[protonLeah]

One option: check the linked cell for True

[PCI]

A check box can have a linked cell to show the status of the checkbox.
You could use this cell for your macro
Attach an Excel sample file if you want more details

[Norie]

How did you create the checkbox?

If it's from the Forms toolbar you could use something like this.

Please Login or Register  to view this content.