How to hide and unhide with checkboxes - multiple checkboxs do multiple different things
Category: [Excel] Demo Available
How to hide and unhide with checkboxes - multiple checkboxs do multiple different things
Requirement:
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.
Solution:
Code:
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.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| 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 |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.