Can I create a checkbox that when ticked, shows an additional area to input information?
Hi all,
I'm creating a basic form or templateusing Excel 2010 where the user will fill out information (See attached screenshot) I'd like to incorporate two a check boxes, that when ticked, change the display of the second table, either adding, removing or splitting of of the current columns in to two?
If this is not possible it will be acceptable that when a checkbox is ticked, the title text at the top of a specific collumn changes.
Is this, or any variation of, possible using Excel 2010.
Many thanks
Will the check boxes be on
Will the check boxes be on the worksheet or on a VBA form?
If you add an ActiveX checkbox called CheckBox1 then modify the following code
Private Sub CheckBox1_Change()
If CheckBox1 = True Then
Range("A1").Value = "Selected"
Else
Range("A1").Value = "Not Selected"
End If
End Sub
HTH