G Guest Jan 9, 2004 #1 Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.
Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.
R Ron de Bruin Jan 9, 2004 #2 Hi Matt I advise you to use the checkboxes from the control toolbox. You have much more control then. You can use this in the Sheet module Private Sub CheckBox1_Click() If Me.CheckBox1.Value = True Then Me.CheckBox2.Visible = False Else Me.CheckBox2.Visible = True End If End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) Matt said: Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the Click to expand... code(Worksheet or Workbook)? Thanks.
Hi Matt I advise you to use the checkboxes from the control toolbox. You have much more control then. You can use this in the Sheet module Private Sub CheckBox1_Click() If Me.CheckBox1.Value = True Then Me.CheckBox2.Visible = False Else Me.CheckBox2.Visible = True End If End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) Matt said: Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the Click to expand... code(Worksheet or Workbook)? Thanks.
