Anyways, I'm creating an Excel spreadsheet with ActiveX controls. It should be fairly easy, right? Not so much.
Ok, so, I have a check box named "CheckBox1" and what I would like to happen is that when the checkbox is checked, Sheet #2 is Visible. When the checkbox is un-checked, Sheet #2 becomes hidden.
With the code below, my sheet will be hidden, but un-checking the box does not make the sheet visible again. Am I missing something? It should be a simple if/then/else statement, right?
Thanks in advance.
Private Sub CheckBox1_Click() If (CheckBox1 = 0) Then Sheet2.Visible = False Else If (CheckBox1 = 1) Then Sheet2.Visible = True End If End If End Sub