The user is trying to have a manual expand list for a user to go down. The user would like to have macro tied to my checkboxes that when it is checked it unhides the rows beneath (expanding the selection options) then hides again once the check box is unchecked. The user has several sections that he/she would like to apply this to.
Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("6:13").EntireRow.Hidden = True Else Range("6:13").EntireRow.Hidden = False End If End Sub
Obtained from the OzGrid Help Forum.
Solution provided by GoldenExcel.
|How to use Excel VBA code to hide based on criteria|
|How to reference text in cell to unhide worksheet|
|How to unhide worksheets identified by specific cells in main sheet|
|How to hide rows based on 2 value|
|How to hide columns in sheet 2 based on data change in sheet 1|