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.
*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.Please Login or Register to view this content.
Bookmarks