Usually you use option buttons for mutually exclusive choices like you have.
Anyway, you need to attach a macro to your option button/check box. Double
click it in Design Mode (settable in the Control Toolbox toolbar) and paste
code into the sheet module similar to this:

Private Sub OptionButton1_Click()
Worksheets("Sheet3").Activate
End Sub


--
Jim
"SLKoelker" wrote in message
...
|I have a checklist in excel. For each question the person filling it out
must
| choose Yes No or NA (all checkboxes created from Control Toolbox). For all
NA
| answers the person must give a reason on sheet 3 that I renamed NA
| Clarification. Is there a way to make it so that when someone checks the
box
| for NA it automatically goes to the NA Clarification sheet (sheet 3)? I
don't
| know if there is a hyperlink or formula I can put in for that? Please
help.
| Thanks in advance.