Checkbox to open another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
|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.
 
THANKS!!! it worked great.

Just one more thing, is there a way to uncheck all the checkboxes at once
instead of individually? Please help. Thanks.
 
Again, you need a macro:

Sub UnCheck()
Dim Obj As OLEObject
For Each Obj In ActiveSheet.OLEObjects
If Obj.progID = "Forms.CheckBox.1" Then
Obj.Object.Value = False
End If
Next
End Sub



--
Jim
| THANKS!!! it worked great.
|
| Just one more thing, is there a way to uncheck all the checkboxes at once
| instead of individually? Please help. Thanks.
|
| "Jim Rech" wrote:
|
| > 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
| > | > |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.
| >
| >
| >
 
Back
Top