How to reference a CheckBox on another worksheet.
If I have two worksheets, named Sheet1 and Sheet2 and a checkbox, (chk1) on sheet1, how do I check the value of chk1.value, while working on sheet2?
Printable View
How to reference a CheckBox on another worksheet.
If I have two worksheets, named Sheet1 and Sheet2 and a checkbox, (chk1) on sheet1, how do I check the value of chk1.value, while working on sheet2?
debug.print Worksheets(2).chk1.value
or
debug.print Worksheets("sheet2").chk1.value
Seahag