Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox to open another worksheet
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox to open another worksheet
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox to open another worksheet
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 "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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox to open another worksheet
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 "SLKoelker" wrote in message ... | 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 | "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. | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
How to insert a CheckBox in a Excel 2007 worksheet?? | Excel Worksheet Functions | |||
How do I keep my checkbox from moving after I print the worksheet | Excel Discussion (Misc queries) | |||
checkbox and worksheet | Excel Discussion (Misc queries) | |||
how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions |