Checkbox

[dmerchen]

Can I test if a checkbox on a sheet within Excel is checked, and if it is make a checkbox on another sheet be checked too?

If chkbox1.value=checked then
chkbox 2.value=checked
End if

Wouldn't this work? Checkboxes don't really depend on the sheet they are on correct. Can you just give them a name and run these type of if then statements? Thanks for any help.

[lintz]

You're on the right track - only a small change needed which is below. You need to specify which sheet the 2nd checkbox is in for your code to work.

If chkbox1.value = True then
SheetName.chkbox2.value = True
End if