i got 5 checkboxes and need them to be linked to range a1:a5.

the caption on the checkbox is "report printed" then i need that displayed
in a1, if caption on textbox2 "other" then a1 display "other"

and textbox2 display in range b5